Axis control by Percentage

[Sekars]

Hello Friends

Please find the attached file (Axis control by Percentage.xlsx).

In Vertical Format axis it automatically taking the values as Min. 490 and Max 560.

Instead the maximum value is 550 (573 at +4%) and minimum value is 495 (515 at -4%)

Is there any way to input the values in the terms of % so that maximum will be 573 and minimum will be 515.

thanks in advance

[MrShorty]

There is no way to change or alter the algorithms behind Excel's "automatic" axis limit choices. You can always manually enter the desired axis limits, but I am guessing that you want something more automated than that. You can automate these "manual" changes using VBA. I won't re-write a tutorial that is already readily available, so: http://peltiertech.com/link-excel-ch...lues-in-cells/