Define range for graphs/charts with validation list

[janfolmer]

Hi I would like to change the range for a graph with a dropdown list
See attached picture to get the feeling. I don't want to have 12 chart
for each month, but one graph and a validation dropdown list with whic
I can dictate the graphs' data ranges.
If I select January in the dropdown list, I must take the january rang
for the graph, etc.
I do not know if this is possible, but if it is possible that would b
an awesome solution

+-------------------------------------------------------------------
|Filename: example.jpg
|Download: http://www.excelforum.com/attachment.php?postid=3757
+-------------------------------------------------------------------

 

[bj]

this sounds as though a pivot table chart would do exactly what you need.
check out help on pivot tables and their charts.

 

[Debra Dalgleish]

Jon Peltier has instructions for interactive charts that you could adapt
to your worksheet:

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