Hi everyone,
I have a list of names (i.e 100 of them) that contain their segmentation profile:
i.e positive, neutral or negative, colour coded green, yellow and red respectively for 4 quarters of the year.
I created a chart that contains all the counts for the segmentations:
i.e
Q1:
positive: 50
neutral: 30
negative: 20
Q2:
etc...
Q3-4 etc...
I then created a pie chart for the count data and added a VLOOKUP to choose the respective quarter of interest.
Now I want to be able to expand a piece of the pie chart (lets say I choose a piece of the pie that is for 'positive' (green) - how would I go about expanding that portion of choice to show all the names of the individuals and their respective information that are categorized as 'positive'? Specifically n a different table if possible?
Thanks
Bookmarks