I'm sure you could adapt this technique to your situation:

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

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


"zephyr" wrote in message
...
I have 10 charts; each chart has five curves generated from five rows.

Instead of having 10 charts on the worksheet, is it possible to have a
drop
down box so that only one of the charts with the five curves can be
selected
and shown.

Is there a simple way of doing this? Any assistance would be appreciated.

Zephyr