Macro to specify axis min and max scale? Excel 2003

[lingyai]

Hi, Sorry if this is a naive question, I'm not proficient in VBA, I usually just record macros, an approach which doesn't seem to work with this problem, in Excel 2003... What I'd like to do is this. Say I have a chart, sometimes I'd like the y-axis to be scaled automatically, other times, I would like to set the y-axis min and max value manually, without having to right click on the axis and set the values in the dialogue box. What I'd like to do is to offer the user a choice which can be made on the face of the worksheet, between:

a) entering a 1 in a named cell, e.g "scale_options", which would result in the scale being set automatically, and

b) entering a 2 in "scale_options", and then manually entering the max y-axis value in another named cell e.g "axis_max", and manually entering the min y-axis value in yet another named cell e.g. "axis_min"

and finally, running a macro which implemets the choice.

Is this possible/ terribly involved?

I'd be grateful for any help

[Andy Pope]

Here is how to link the min/max
http://peltiertech.com/Excel/Charts/...nkToSheet.html

You can add further code to check another cell for use of values or automatic

[lingyai]

Thnak you Andy!