Notifications
Clear all
Excel Dashboards
2
Posts
2
Users
0
Reactions
54
Views
Topic starter
Hi,
I have a line chart that shows workstations needed from Jan 01 2020 until 31 Dec 2022.
Management want to be able to filter for the various financial year quarters.
On a data tab I have the underlying table (excel table created using Ctrl + T) for the line chart and it has a column stating which fin year qtr it falls into.
Is there a way on my 'Presentation' tab to have a selection that will drive the filter in the MachineNeeds table on my 'Data' tab in order to filter for the selected qtr?
Thanks
Posted : 06/06/2020 12:29 am
Hi Steven,
If you have Excel 2013 or later you can add Slicers for Excel Tables and put the Slicer on any sheet i.e. it can go on the same sheet as your chart.
Mynda
Posted : 06/06/2020 8:33 pm
