Pie to Pie Chart - Renaming Category Name "Other" through VBA code

Highlighted
Occasional Visitor

I am trying to create a pie of pie chart for interactive dashboard and want to show category names as well. but in first pie the category name of slice which represents the total of second pie by default comes as "Other" but I want to show the actual name or something different which explains the data. I can do this by manually changing it but when data changes the group will change as well then I want it to change automatically. any suggestions would be appreciated or vba code to help with the problem. thanks

0 Replies