Grouping Chart Data

Lamda

New Member
Joined
Mar 28, 2014
Messages
35
Hey All,

I have a question around chart data - so I've pulled back a set of data that has lets say 30 different values. Its obviously not very feasible to do this in a pie chart as you end up with a ton of labels that make up jibberish. Is there a way in the chart to say select the top 5 or 10 and then group everything else into an 'other' designation? The only way I can think of to do this manually is to create a new row and then give it a condition to run through all 30 values and then use that as a chart option but I was wondering if there was a better way to where I didn't have to do that. I know I could use a different chart that shows more valued better but am needing to do this in a pie chart and essentially group 20-25 values into one value to make the pie chart usable. Any suggestions? Thanks!
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
30
28
26
24
22
20
18
16add the 10 smallest
14
1211=SMALL($A$1:$A$30,E10)
1121
831
642
454
266
2977
2788
2599
231011
2150add them up
19
17
15list the 20 biggest
13130
11229
9328
7427
1526
1625
1724
823
922
1021
1120
1219
1318
1417
1516
1615
1714
1813
1912
2011
2150sum of the smallest

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top