Multiple charts on one page - Y-Axis produces wierd format on 2nd chart

[Former Member]

Hello,

I have found something strange while using CR 2011.

1. i create a bar chart showing Sales Revenue vs GL Revenue. The chart is horizontal. The scale shows 4.5 m, 6.5 m, 7.5 m etc

2. i add a second chart to the page, no matter what type of bar chart, the Y axis scale on the first chart changes to 450m, 650m, 750m...???

for the life of me i cannot fix it, unless i make the charts in two seperate files..

any ideas?

[JWiseman · Accepted solution]

hello,

what is most likely happening is that the record set being returned changes when the 2nd chart is added.

this would be because chart 2 contains fields from one or more tables that are not referenced by chart 1. by adding chart 2, you then add a new set of fields and tables to the sql query and thus the total data set on the report changes.

a solution would be to use a subreport as it sounds like you've already done.

jamie