I have a report divided by section (a region) and each section has a column chart showing my revenue by month.
The problem is that the scale of the chart is set to the highest values of the revenue no matter what the region is.
Example: if in section/region A, my values range from 0 to 40 and in section/region B, my values range from 0 to 3000, the scale for the chart in all sections will be from 0 to 3000 and the chart in section A will be unusable!
Has anyone a trick to solve this without creating a report by region?
The problem is that the scale of the chart is set to the highest values of
the revenue no matter what the region is.
Try bringing up Edit chart and change the chart type to the stacking bar or line chart (Use the Series tab, and subtype chart type). If there is only one measure, it will look the same, but the scale will be different for each chart.
Regards
Richard Harris
CMS Team - Telewest Woking
Tel 01483 251597
You wrote: "the scale of the chart is set to the highest values of
the revenue no matter what the region is"
If you put on the drill mode, the chart will scale automatically. The only fall-back being that you cannot print all regions in one go. But then, if you were going to create a report per region…
I found my error, I was not selecting the right chart subtype. Thanks for your answer.
Toan
From: Behalf Of Wagt, M.
Sent: Friday, October 23, 1998 9:25 AM
Viet-Toan,
You wrote: "the scale of the chart is set to the highest values of
the revenue no matter what the region is"
If you put on the drill mode, the chart will scale automatically. The only fall-back being that you cannot print all regions in one go. But then, if you were going to create a report per region…