Hi,

I'm making a dashboard to summarise some athlete training data. I have a dashboard that includes some bar graphs, a radar chart and a table - these are all set up using multiple pivot tables on another tab.

At the moment, to update all of these charts, I need to change all the dates on the pivot table manually.


Is there any simple way I can add a combo box to the dashboard to select a date, which will then update all the pivot tables and therefore update the dashboard?

I'm a bit of a newbie so ideally something that doesn't involve me typing some code!


Thanks