Forum Discussion
What is the Chart Axis Bounds Calculation when set to Automatic?
Hi All, Does anyone happen to know what formula is used by the developers for calculating Chart Axis Minimum, and Maximum, bounds when they are set to Auto (Ref Figure 1 below)? Once this is k...
So, since my last post I've created a column chart with a single record, then used vba to create a dataset from 0 to 100, in 0.01 increments, and logged the chart's "MaximumScale" bounds that are automatically created for the vertical axis as a list of records.
I've then graphed these outputs (Ref: figure 3 below) to try to determine the algorithm used by Microsoft to automatically adjust the vertical axis.
If anyone knows of an easy way to reverse engineer this dataset your help would be greatly appreciated.
figure 3
TIA
Mark Porter