Cell reference in chart scale?

[Bill Wilson]

Can I use a cell reference, rather than absolute value, to set min or max
Y-axis scale in chart? I think I have done this before but cannnot remember
how. Thanks.

 

[Andy Pope]

Hi,

Not directly. You would need to use event code to capture cell changing
and then apply value to chart.

Jon Peltier has details.
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

Cheers
Andy