F
Flip
I have xy data I need to show in a chart that changes with categories. My
data looks like this:
PrimaryCategory: values=A,B
SecondaryCategory: values=S,M,L
XData: 0, 500, 1000, 2000 (for each Primary-Secondary combo)
YData: values paired with XData
The report needs to show an xy chart for each Primary-Secondary combo. What
I'm getting is the same chart over and over (four charts for each
Primary-Secondary combo) that shows the averages of all Y values at each X,
even though I did not choose to average values in the chart wizard. The
report is grouped on PrimaryCategory, then on SecondaryCategory. The chart
is in the Details section. RowSource says "SELECT [XData],[YData] FROM
Table1;". Row Source Type is Table/Query.
At this point I'm stumped. This seems like it should be really easy, but
I'm more used to Excel.
Suggestions?
Thanks.
data looks like this:
PrimaryCategory: values=A,B
SecondaryCategory: values=S,M,L
XData: 0, 500, 1000, 2000 (for each Primary-Secondary combo)
YData: values paired with XData
The report needs to show an xy chart for each Primary-Secondary combo. What
I'm getting is the same chart over and over (four charts for each
Primary-Secondary combo) that shows the averages of all Y values at each X,
even though I did not choose to average values in the chart wizard. The
report is grouped on PrimaryCategory, then on SecondaryCategory. The chart
is in the Details section. RowSource says "SELECT [XData],[YData] FROM
Table1;". Row Source Type is Table/Query.
At this point I'm stumped. This seems like it should be really easy, but
I'm more used to Excel.
Suggestions?
Thanks.