nyconfidential
New Member
- Joined
- Jul 22, 2015
- Messages
- 49
- Office Version
- 365
- 2016
Hi there - I'm trying to create a pie chart that will only have two sections: the sum of the top 5 values, and the sum of all of the other values in the column. For example:
Let's say I have a list of 15 cars - one part of the pie chart will be the sum of the 5 most expensive cars. The other part of the pie chart will sum up the price of the other 10 cars. Is there a simple way to do this? I can always grab the sum of the top 5 via a pivot table - but the number of the other values will vary, I could have 10, 20 or 30 other cars. Thanks for your help.
Let's say I have a list of 15 cars - one part of the pie chart will be the sum of the 5 most expensive cars. The other part of the pie chart will sum up the price of the other 10 cars. Is there a simple way to do this? I can always grab the sum of the top 5 via a pivot table - but the number of the other values will vary, I could have 10, 20 or 30 other cars. Thanks for your help.