Minimum and maximum value of Axis set by user by reference to form

[Guest]

Excel seems to have 2 alternatives for defining the min/ max value of an
axis: either automatically or preset by the user.

But is there any way that the minimum and maximum value that the axis is
defined by the user based on the values of the spreadsheet (i.e., halfway
between the above two apparent options provided by microsoft)?

 

[Guest]

Yes, you can tie axis values to worksheet cells via a macro. The process is
described via the link below . . .

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html