Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoScale on Charts
Does anyone know why when creating a chart within VBA using the
AutoScale Max/Min settings set to True, that some Chart have the range (Y axis) beginning @ zero and when I run the chart for a different person are data series it begins AutoScaled..... (not zero) I would like the scale to result as whatever the Max number is of the series is add +10 and the lowest number of the series -10 so that the Chart is a bit more readable then have those few the start @ zero. Any suggestions? TIA -Randy- .. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoScale on Charts
Try out Tushar Mehta's Auto Chart Manager at http://tushar-mehta.com
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Randal W. Hozeski wrote: Does anyone know why when creating a chart within VBA using the AutoScale Max/Min settings set to True, that some Chart have the range (Y axis) beginning @ zero and when I run the chart for a different person are data series it begins AutoScaled..... (not zero) I would like the scale to result as whatever the Max number is of the series is add +10 and the lowest number of the series -10 so that the Chart is a bit more readable then have those few the start @ zero. Any suggestions? TIA -Randy- .. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autoscale fonts for charts in 2007 | Charts and Charting in Excel | |||
link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
Autoscale a Line Chart to stack the curves | Charts and Charting in Excel | |||
Define Autoscale parameters in Chart | New Users to Excel | |||
Can a value axis autoscale to something other than 0 for the min? | Charts and Charting in Excel |