Combining Pie Chart Data

[jakesteen87]

I have a pie chart that has a lot of data slices in percentages. I want to combine slices that are under a certain percentage so I can see the top 7 percentages, and the rest will be grouped in an "other" category. Any help is greatly appreciated.

Thanks!
-Jake

[teylyn]

Hi,

you need to do the summing up in your data table. Excel will chart the data points as they appear. You cannot do any summarising in a chart. It needs to be done in the data.

cheers

[jakesteen87]

Cool that's what I need to know! Thanks!