Jeff -
Try the second approach he
http://peltiertech.com/Excel/Charts/...eDropDown.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"Jeff" wrote in message
...
Hi,
I have a spreadsheet with about 15 charts. I want to be able to
automatically switch between charts in the "Main" tab based on an input.
So
for example if I input "1" chart #1 would appear in the "Main" tab. All
of
the charts are different (they have different units for the X and Y
values)
so I cannot use a named range (at least I don't know how to use the named
range).
Thanks