Scaling Charts
If multiple charts in a story contain the same measure, the measure values may be scaled
differently in different charts, which can make comparisons difficult. You can scale the
charts so that measures have the same scale across multiple charts.
Context
Note
- Chart scaling is applied to all of the pages in a story, but the scaling may
be different for the same measure on different pages, because the scaling
factor is calculated separately for each page.
- You can exclude charts from the scaling, for example if a chart contains
data that is much larger than the data in other charts, making the other
charts look small.
Procedure
-
Open the story that contains the charts you want to scale, and on the toolbar select
(Chart Scaling).
-
Select the measures that you want to scale.
The affected charts in the story are rescaled automatically.
Note
Once a measure is
included in an axis scaling rule, that measure can't be included in another
axis scaling rule.
-
After scaling charts, you might want to set the bar widths in the scaled charts to a
consistent size. To do so, hover over the axis scaling rule you just created
under Chart Scaling, and select .
Type the number of pixels you'd like to set the bar width to. To revert back
to the default widths, delete the number you typed.
When conflicting bar widths are defined, the width rule of the first measure
on the axis is applied to the overall chart.
When an axis scaling rule is deleted, any associated bar width setting is
also deleted, and the bar widths revert to the default sizes.
-
To exclude a chart from scaling, do the following:
-
Select the chart, and then select .
-
In the Styling panel, expand Chart
Properties, and then set Break
Scale to On.
-
To change which measures are scaled, hover over a measure in the Scaled
Measures list, and select
(Edit Scaled Measure).
-
To remove scaling for a measure, hover over the measure in the Scaled
Measures list, and select
(Remove Scaled Measure).