Auto Scaling of Data¶
When auto scaling is enabled, data will be rounded and scaled into the unit of measure of the largest number (positive or negative) in the data set, have an applicable number format applied and also be appended with the appropriate indicator for the unit of measure.
The units of measure and indicators are as follows:
|Unit of Measure||Appended Indicator|
|Up to a Thousand||none|
With auto scaling enabled all data and label number formats will be set to
auto and the Value Axis Min/Max settings will be enabled and
The rules of auto scaling are to format the numbers in the chart to three significant digits so that depending on the unit of measure the number is in, the correct precision can be shown.
- Single units will get two decimal points of precision, e.g. 1,432,000 will become 1.43 M
- Tens units will get one decimal points of precision, e.g. 10,821 will become 10.8 k
- Hundreds units will get no decimal points of precision e.g. 654,032,923 will become 654 M
Updating Existing Charts¶
To update existing charts to take advantage of auto scaling, open them up in Chart Design mode and toggle the Auto Scale property off and then on. This will cause a reset of all the number and label formatting in use in your chart and set the defaults for auto scaling.