Simple Line Graph Problems

[skuhlman]

My Data Set Looks Like This

Legend Days QtySold
1999 31 1
1999 60 2
1999 91 8
1999 122 15
2000 31 0
2000 60 5
2000 91 10
2000 122 18
2001 31 0
2001 60 0
2001 91 3
2001 122 3

I am trying to get a line graph with a line for each legend graphing DAYS on the X axis and the Quantity on the Y axis.

What I'm getting is correct for the first legend, but the 2nd legend starts at the end of the first legend instead of starting at the beginning above/under the 1st legend. The 3rd legend is doing the same, it's adding to the end instead of starting at the beginning again.

Any suggestions?

 

[lbass]

Using the advanced layout, for your "on change of" fields, first enter {table.days} and then {table.legend}, and use {table.qtysold} for your summary field. That should give you three lines, one for each legend value, and four X-axis values, 31, 60, 91, and 122.

-LB