Active Member
March 19, 2023
I am trying to create a dashboard to monitor daily performance. I like the dashboard to be able to provide me infographic screen while enabling me to go through each date and see the results. For this matter, I created a pivot table with a slicer that let me monitor results for LDGT, LDGB, and LDGTL in a hold-wise manner. ( you can find the results in the attached file)
As you can see in the attached excel file, with the slicer, you can monitor the table information in accordance with date, hold, and hold value.
I require LDG PROG, AWAITING CARGO, and MACHINERY STOPPAGE to be linked to this slice and show results for each subject (LDG PROG, for instance) in a doughnut chart as I showed in the attached excel file, sheet “LDG PROG”.
In the sheet “LDG PROG”, I showed an example of the type of doughnut chart I am seeking for.
Let us imagine that we have created a doughnut chart for LDG PROG and linked it to the slicer that we previously created. Therefore, as I go through each date, a single doughnut chart pops up and shows the progress percentage, while other bar charts are showing information regarding the chosen date.
Your kind assistance would be highly appreciated.
July 16, 2010
Hi Amin,
Thanks for sharing your file. I'm not sure I understand your question and desired result. If you simply want the Date Slicer on the Dashboard sheet to also filter the PivotTable and connected doughnut chart on the LDG PROG sheet, then you can right-click the Slicer > Report Connections > check the box for PivotTable4, which is the one on the LDG PROG sheet.
I hope that answers your question, but let me know if I've misunderstood.
Mynda
1 Guest(s)