Combining Data on a pie chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark C - 17 Dec 2004 17:29 GMT

I have a data range that I am charting to show percentage of total of the
various data categories. The problem is there are a lot of categories under
2% I wish to combine into 1 entitled 'Misc'

Does anyone know a way to combine several data points into one.

TIA - Mark

Reply to this Message

Barb Reinhardt - 17 Dec 2004 17:55 GMT

Try selecting a Pie chart and choosing Pie of Pie or Bar of Pie.

> I have a data range that I am charting to show percentage of total of the
> various data categories. The problem is there are a lot of categories under
[quoted text clipped - 3 lines]
>
> TIA - Mark

Reply to this Message

Mark C - 17 Dec 2004 18:27 GMT

Barb,

Thanks, that combines the small percentage data but then shows those points
as a subset pie or bar. I just want to combine them into one? Any further
suggestions?

Thanks - Mark

> Try selecting a Pie chart and choosing Pie of Pie or Bar of Pie.
>
[quoted text clipped - 6 lines]
> >
> > TIA - Mark

Reply to this Message

Jon Peltier - 17 Dec 2004 19:10 GMT

Mark -

It might be easiest of all to do a little math in the spreadsheet to add up these
Misc slices, and plot the adjusted data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

> Barb,
>
[quoted text clipped - 16 lines]
>>>
>>>TIA - Mark

Reply to this Message