Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Auto-Scale
I am having problems with auto-scale automatically turning on. I have tried a
couple of different methods to turn it off. I have reinstalled the software. I have had the user recreate the entire spreadsheet. I have tried suggestion from Article ID: 215573. I have done everything I can think of and auto scaling still keeps being turned on. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Auto-Scale
Hi,
I presume you mean the Auto options on the Scale tab? Auto Scale is the default for all new charts, you can't change the default. Auto scale automatically turns off when you type a value into the box to its right. This is true even if the value you enter is the same one that was there when Auto was on. what you can do is create a template chart type that has pre entered values on the Scale tab, thus overriding the Auto feature. When you create a new chart use the template. You create a chart template in 2003 by designing the chart and then choosing Chart, Chart Type, Custom Type, User defined, Add.... And that is where you find it when you want to apply it. If this helps, please click the Yes button cheers, Shane Devenshire "Chris" wrote: I am having problems with auto-scale automatically turning on. I have tried a couple of different methods to turn it off. I have reinstalled the software. I have had the user recreate the entire spreadsheet. I have tried suggestion from Article ID: 215573. I have done everything I can think of and auto scaling still keeps being turned on. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Auto-Scale
Sometimes people misunderstand the Format Axis dialog. In the scale tab,
when you enter a value for an axis scale parameter, Excel unchecks the Auto box. If you go back and check this Auto box, Excel reverts to autocalculating its own parameters. While it may seem silly that someone would recheck the Auto box, I have seen it enough times, done by intelligent people, to suspect it in a case like this. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Chris" wrote in message ... I am having problems with auto-scale automatically turning on. I have tried a couple of different methods to turn it off. I have reinstalled the software. I have had the user recreate the entire spreadsheet. I have tried suggestion from Article ID: 215573. I have done everything I can think of and auto scaling still keeps being turned on. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Scale x-axis | Charts and Charting in Excel | |||
Auto Adjust Scale | Charts and Charting in Excel | |||
Getting a useful Auto Scale | Charts and Charting in Excel | |||
Y Axis Auto Scale | Charts and Charting in Excel | |||
Auto Year scale | Charts and Charting in Excel |