I have a pivot table which I have created a stacked pivot chart but I am unable to create a data label that shows the overall total for each stacked column (at the top of each column). I can get the pivot table to show overall total but my challenge has been to transform into the stacked pivot chart. The pivot table and chart will dynamically change according to slicer tools so the overall total of each stacked column will also need to reflect changes.
I attach a sample worksheet for your reference.
I thank you for your time and support.
Bookmarks