Using Charts in Groups

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JMacC - 08 Feb 2008 15:31 GMT

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?

Reply to this Message

JMacC - 12 Feb 2008 18:55 GMT

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.

> I'm writing a report that I want grouped by alloy-temper. Using the
> following query I inserted a chart into the group section.
[quoted text clipped - 10 lines]
> Why is the print view so different from the preview? Why is this not
> grouping by temper? What am I missing?

Reply to this Message