Is it possible to create this line graph?

[cbruch]

I need to create a line graph from a table which contains the following fields:
Division
Week number
# of homes

The graph should only print once on the report with a line for each division. The x axis should have the week number, and the y axis should have the # of homes. It also must have a legend to identify each line on the graph.
Is this possible? Everything I have tried results in only one line on the graph.
I am using Crystal Reports 9.

 

[mbarron]

On the data tab of the Chart Expert, the drop down should be "On Change of" Add your week field first to "On change of" box then add the division field. For the "show values" choose your homes field.




Mike

 

[mbarron]

On the data tab of the Chart Expert, the drop down should be "On Change of" Add your week field first to "On change of" box then add the division field. For the "show values" choose your homes field.

Mike

 

[cbruch]

Mike-
Thanks a lot. That seems to work.