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

M

MJ

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!
[email protected]
 
J

Jon Peltier

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

- Jon
 
Top