how to setup only one chart and change data from a drop down

[Andre]

Hi,

How can I make use of only one chart on a sheet that can be changed
dynamicaly by using a drop down to display a new chart.

Example data is as follows:

Time period is months from July to june
Benchmark
Threshold
Actual monthly value.

jul aug sep oct nov dec jan feb mar apr may jun
Benchmark 20 20 20 20 20 20 20 20 20 20 20 20
Threshold 10 10 10 10 10 10 10 10 10 10 10 10
actual1 18 23 14 15
Benchmark 100 100 100 100 100 100 100 100 100 100 100 100
Threshold 78 78 78 78 78 78 78 78 78 78 78 78
actual2 67 87 88 78
Benchmark 0.012 0.012 0.012 0.012 0.012 0.012 0.012 0.012 0.012 0.012 0.012 0.012
Threshold 0 0 0 0 0 0 0 0 0 0 0 0
actual3 0.1 0.11 0.13 0.02


i.e. I want to select different data to display each time on only one
chart.

Thanks

Andre Melcher

 

[Debra Dalgleish]

Depending on the amount of data that you have, the following may work:

1. Add a column to the table, with a heading , e.g. Chart#
2. In this column, enter a number in each row, to indicate the chart
in which the data should be plotted.
3. Create a chart from all the data, but not including the Chart# column
4. Select a cell in the table, and choose Data>Filter>AutoFilter
5. From the dropdown in the Chart# column heading, select a number

The chart should display only the data for the selected chart number.

 

[Debra Dalgleish]

And Jon Peltier has some instructions for creating a chart from selected
series:

http://www.geocities.com/jonpeltier/Excel/Charts/ChartByControl.html