Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
x-axis scaling | Excel Discussion (Misc queries) | |||
x-axis scaling | Charts and Charting in Excel | |||
Scaling axis | Charts and Charting in Excel | |||
axis scaling | Charts and Charting in Excel | |||
Auto Scaling of Y-axis | Charts and Charting in Excel |