Using Charts in Groups

J

JMacC

I'm writing a report that I want grouped by alloy-temper. Using the
following query I inserted a chart into the group section.
SELECT qrySiFeCuVSyts.[Silicon], qrySiFeCuVSyts.[YTS],
qrySiFeCuVSyts.[Alloy-Temper] FROM qrySiFeCuVSyts;

The chart is a scatter chart using YTS an the Y axis and Si on the X
axis.When using the chart wizard the chart preview section looks normal. I
used the Alloy-Temper to link the chart to the report, and then print
previewd the chart. The Chart ends up with the YTS on the Y axis, but the X
axis has everything center on1. when I turned on the legend, there was a
point for each Si value!!??

Why is the print view so different from the preview? Why is this not
grouping by temper? What am I missing?
 
J

JMacC

Answered my own question. For some reason MSGraph changed the series in
Columns (as seen in the preview) to series in Rows. Changed the series
orientation. Then moved graph from detail section to group header section.
Prints the way I wanted.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top