[zephyr]

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

[Jon Peltier]

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

[Gary''s Student]

1. create or record a macro for each chart that builds and positions the chart
2. insert a data validation pull-down in some cell that lists the possible
charts
3. insert a worksheet event macro to monitor the pull-down cell and
delete/build a chart based on the input

--
Gary''s Student - gsnu200790


"zephyr" wrote:

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

[Ed Ferrero[_2_]]

And for a couple of different ways...

Look at Chart Selector, Chart Selector Version 2, and Reporting
from this page http://www.edferrero.com/ExcelCharts...2/Default.aspx

Ed Ferrero
www.edferrero.com

[zephyr]

I will have a go at using the suggestions provided, many thanks for the
responses provided.

Zephyr

"Ed Ferrero" wrote:

And for a couple of different ways...

Look at Chart Selector, Chart Selector Version 2, and Reporting
from this page http://www.edferrero.com/ExcelCharts...2/Default.aspx

Ed Ferrero
www.edferrero.com