Notifications
Clear all
Topic starter
Hello, I currently have 25 locations with sales and would like to create a Pivot chart that shows the top 5 individually and have a 6th section labeled "all others". I found that I can have a chart with top 5 only which does not help show market share or have all 25 which is too crowded for a pie chart.
The picture example is what I'm trying to create with a pivot chart.
Thank you
Posted : 27/02/2021 9:55 am
Hi Jake
1) Sort your pivot table base on the %
2) Group the bottom 20 and rename it as "All others"
3) Collapse entire fields in the Pivot Table.
4) Create the Pivot Pie Chart
5) Add the data labels and format accordingly.
Please refer attachment.
Hope this helps.
Sunny
Posted : 28/02/2021 9:24 am
Topic starter
Thanks Sunny! Appreciate the help
Posted : 28/05/2021 10:59 am
Hi Jake
Thanks for your feedback.
Glad to know that it helps.
Sunny.
Posted : 29/05/2021 3:48 am