Using Named Formulas in Charts

D

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?
 
Top