Hello all,
Hoping someone can help, if this is possible.
I have a PivotChart where I have filtered the PivotTable to show the top 10 results. The X axis has subcategories and I have the legend series set to the categories that house the subcategories. The issue is that the legend on the PivotChart shows ALL categories, where I want it to show only the categories that contain the top 10 subcategories. There are 12 total categories, but after the top 10 filter is applied, there are only 6 that cover the top 10 subcategories so I only want the legend to show these 6.
How can I fix the legend to show this?
Bookmarks