ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Change the value axis scale (https://www.excelbanter.com/charts-charting-excel/443-change-value-axis-scale.html)

SJ

Change the value axis scale
 
I have tried selecting the Value axis and changing the minimum, maximum,
major & minor unit - does not seem to accept the changes - am missing a step,
i guess.Please advise.

John Mansfield

SJ,

Double-click on the Y-Axis labels to bring up the Format Axis dialog box.
Go to the Scale tab. When you manually change the maximum, minimum, etc.
make sure that you don't have the "Auto" options checked. For example, if
you make a manual change to the maximum and then check the auto option for
the maximum, the scale will not change.

----
Regards,
John Mansfield
http://www.pdbook.com

"SJ" wrote:

I have tried selecting the Value axis and changing the minimum, maximum,
major & minor unit - does not seem to accept the changes - am missing a step,
i guess.Please advise.


SJ


Thank You. Very helpful.


All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com