Magnatolia
Board Regular
- Joined
- Jan 19, 2012
- Messages
- 81
- Office Version
- 365
- Platform
- Windows
Hi all,
I'm building a kind of dashboard using a couple of Pivot Charts and a few slicers linked to the underlying Pivot Tables.
I want to recreate a clustered column chart as a Pivot Chart to have it updated by the slicer. It shows the person and how many documents they created, and how many are marked for amendment. I can create two separate Pivots but its easier to compare as a clustered column view.
Thanks!
I'm building a kind of dashboard using a couple of Pivot Charts and a few slicers linked to the underlying Pivot Tables.
I want to recreate a clustered column chart as a Pivot Chart to have it updated by the slicer. It shows the person and how many documents they created, and how many are marked for amendment. I can create two separate Pivots but its easier to compare as a clustered column view.
Thanks!