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