Dropdown Menu Updating Multiple Charts

[FoxyCoop]

Hi all,

I have 4+ charts that I want to be able to filter with the drop down menu on the side.

I've managed to link it to one chart with it working perfectly, however I would like all charts to update when a month is selected.

any tips?

I hope my explanation makes sense.

 

[Anthony47]

I suggest you try using "slicers" and "timelines", rather than developing your own interface.
I found useful information on these tools on this page: Excel Slicers - Introduction, what are they, how to use them, tips, advanced concepts, interactive charts & reports using Slicers & Pivot Tables

 

[FoxyCoop]

I suggest you try using "slicers" and "timelines", rather than developing your own interface.
I found useful information on these tools on this page: Excel Slicers - Introduction, what are they, how to use them, tips, advanced concepts, interactive charts & reports using Slicers & Pivot Tables

Great thanks mate I appreciate it, I will give that a read