Scaling Axis via VBA?
I'm creating a spreadsheet with many charts.
Each chart may have a different range of values - "Deal Count", for instance,
may vary from 1 to 10 on one chart, but from 1 to 145 on another chart.
I want to set each chart's Axis.MajorUnitScale to an appropriate amount.
I'm figuring something like:
---------------------------------
Count < 10 = 1
Count between 11 and 100 = 10
Count between 101 and 1000 = 100
---------------------------------
And so-on....
Do I have to go to each chart's data range, figure out which column has "Deal
Count" in it, figure out how many rows there are, and then do a Max()?
Or is there some simpler way?
The exact MajorUnitScale isn't a religious issue - I just want it so that the
tick mark labels aren't all scrunched together.
--
PeteCresswell
|