Chart Selection

[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

 

[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

 

[Ed Ferrero]

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/tabid/102/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