Cell reference in chart scale?
 

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.

Cell reference in chart scale?
 

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/...nkToSheet.html

Cheers
Andy

Bill Wilson wrote:
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, Microsoft MVP - Excel
http://www.andypope.info