Log In
Register
Home
Active Member
March 19, 2023
Offline
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.
October 5, 2010
Offline
Hi Amin,
No file is attached, please try again and click on the Start Upload button to load the file.
Also, you've posted this in the VBA forum. Are you after a VBA solution? I assume not so I've moved this to the Dashboards & Charts forum.
Regards
Phil
Active Member
March 19, 2023
Offline
Hi,
Here is the file that I mentioned in my inquiry.
Any tips would be valued.
July 16, 2010
Online
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
October 5, 2010
Offline
and what about my questios as to whether you want a vba solution?
Active Member
March 19, 2023
Offline
Hi Mynda,
It worked perfectly, thanks a lot.
Cheer up life-saver
1 Guest(s)
