G Guest Oct 31, 2007 #1 I know how to set the scale on a chart with vba code but how would I find (using vba code) what the scale is set to in a cahrt?
I know how to set the scale on a chart with vba code but how would I find (using vba code) what the scale is set to in a cahrt?
A Andy Pope Oct 31, 2007 #2 Hi, This will return the maximum value of the value axis. msgbox activechart.Axes(xlvalue).maximumscale Cheers Andy
Hi, This will return the maximum value of the value axis. msgbox activechart.Axes(xlvalue).maximumscale Cheers Andy
