Using Named Formulas in Charts

[DCSwearingen]

I am using the tutorial from
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

I thought I would go a little further and created two named formulas
with the thought I could use then to set the scale minimum and maximum
for the Y-Axis.

However when I tried to use the named formula I got an error saying
only an integer or decimal number may be used.

Does anyone know of a way to do this short of running VBA every time
the data changes?

 

[Don Guillett]

I suggest a worksheet_change macro to do this for you.


--
Don Guillett
SalesAid Software
(e-mail address removed)
"DCSwearingen" <[email protected]>
wrote in message
news[email protected]...