ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I create a pie chart without duplicating my cells? (https://www.excelbanter.com/charts-charting-excel/106791-how-can-i-create-pie-chart-without-duplicating-my-cells.html)

mj

How can I create a pie chart without duplicating my cells?
 
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!


Jon Peltier

How can I create a pie chart without duplicating my cells?
 
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
_______


"MJ" wrote in message
...
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!





All times are GMT +1. The time now is 04:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com