Hi,
I have a pivot chart that is a pie-chart tying into two pivot tables (the "Report Connections" option for the slicer has both pivot tables selected). I have the data labels on the pie-chart showing the value and category name. Sadly, when I choose a different selection on the slicer (e.g. a different employee to look at) the data labels completely disappear. Do any of you know how to fix this/workaround this? I need the value and category name to show for each slice of the pie any time a new employee is selected without having to reformat each time.
Bookmarks