Getting a drop down list to reference a various data ranges

Hello,

I am trying to get a drop down list to reference different data ranges when I select something from the list.

I have created a Gantt chart and I would like the Gantt chart to change depending on what is selected from the drop down list.

Any help is appreciated!

Hi

have a look at http://www.contextures.com/JPChartIndex.htm

Tons of possibilities

Hi,
depending on your data best solution is:
- use named areas for every chart + picture link: chandoo.org(wp(2013(04(23(interactive-chart-in-excel-tutorial (I can not post links yet, please replace "(" with "/")
- use INDEX. MATCH to pick up portion of data you need and change values for chart: chandoo.org(wp(2013(08(06(how-to-create-a-then-vs-now-interactive-chart-in-excel

I am posting another post, to be able to paste links...

And another one
Now should be ok:
http://chandoo.org/wp/2013/08/06/how-to-create-a-then-vs-now-interactive-chart-in-excel/
http://chandoo.org/wp/2013/04/23/interactive-chart-in-excel-tutorial/