Drop down option in Chart

[speedy_prabu]

Hey guys,

I'm having this doubt, like could there be drop down option added in Chart Sheet.

where i can use the drop down as a option like, if u selected any of the date in it, the Data will change in the chart.

THIS Is all in Chart sheet not in Normal EXCEL Sheet.

Thanks in Advance....

[Andy Pope]

You can use a Forms drop down control and named ranges.

You could try searching for Named Ranges and Dynamic charts.

If you are still stuck post an example of your chart and data and detail what should be chart on choice from dropdown