Minimum Chart Value

[jasonjenkinson]

Hi

I am trying to find out if it is possible to set the minimum value on
the axis of a line graph to a variable on an excel spreadsheet (such
that it is a dynamic number, as opposed to when you input the starting
value of the axis which is static).

Any help is greatly appreciated.

Thanks!

 

[Jon Peltier]

Jason -

As Tushar Mehta (http://tushar-mehta.com) replied to a message right
next to yours:

"By hand, double-click the x-axis, then in the resulting dialog box, the
Scale tab. Adjust the min. and max. values as desired.

"To link these values to worksheet cells, you have to use a programmatic
solution. A free add-in that does this is the 'AutoChart Manager'
available from my web site."

- Jon