Hi, thanks for your quick reply.

I don't really know much about all this and I'm not sure what's going
on from the downloaded example.

It is the second worksheet functionality I need. Why are there two list
boxes for the user to pick from?

And where is the code assigned to?

Thanks.



Jon Peltier wrote:
Try these examples:

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

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


"Gary" wrote in message
ups.com...
Hi,

I'm not sure if what I'd like to do is possible, but hopefully someone
will be able to help me out.

I have an Excell 2003 workbook which contains various sheets. On one
sheet I have 3 charts that are derived from data in the other sheets.

I would like to give the user viewing the charts the option of viewing
chart1, chart2 or chart3 individually, or, if required, all at once.

I would like to do this with a drop down selction box that has the
options chart1, chart2, chart3 and Show All.

If chart1 was selected then the others would be hidden and so on.

Is this possible?

Thanks for any help.

Gary.