How can I create a pie chart without duplicating my cells?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MJ - 23 Aug 2006 21:44 GMT

I am trying to create a pie chart with very simple data. Excel is duplicating
my cells. For instance, if column B has the Company B listed 15 times in
different rows it is creating 15 of Company B in my pie chart. Please HELP!
mj012905@yahoo.com

Reply to this Message

Jon Peltier - 24 Aug 2006 02:13 GMT

You need to summarize the data in a pivot table, then make a chart from this
summary.

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

>I am trying to create a pie chart with very simple data. Excel is
>duplicating
> my cells. For instance, if column B has the Company B listed 15 times in
> different rows it is creating 15 of Company B in my pie chart. Please
> HELP!
> mj012905@yahoo.com

Reply to this Message