Changing Chart with a lookup

[Jeff]

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

 

[Jon Peltier]

Jeff -

Try the second approach here:

http://peltiertech.com/Excel/Charts/ChartTypeDropDown.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______