software

Hi,

I have a spreadsheet with about 15 charts. I want to be able to
automatically switch between charts in the quot;Mainquot; tab based on an input. So
for example if I input quot;1quot; chart #1 would appear in the quot;Mainquot; 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

Jeff -

Try the second approach he

peltiertech.com/Excel/Charts/...eDropDown.html

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

quot;Jeffquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I have a spreadsheet with about 15 charts. I want to be able to
gt; automatically switch between charts in the quot;Mainquot; tab based on an input.
gt; So
gt; for example if I input quot;1quot; chart #1 would appear in the quot;Mainquot; tab. All
gt; of
gt; the charts are different (they have different units for the X and Y
gt; values)
gt; so I cannot use a named range (at least I don't know how to use the named
gt; range).
gt;
gt; Thanks