Thread: Pie Chart
View Single Post
  #2  
Old April 1st, 2010, 05:46 PM posted to microsoft.public.excel.charting
Luke M[_4_]
external usenet poster
 
Posts: 451
Default Pie Chart

By default, Total = 100% so why graph it??

Just select the first two rows and make a graph of that.

--
Best Regards,

Luke M
"Emece" wrote in message
...
I have the following data in Excel:

Total Percentage
Product 1 7 28%
Product 2 18 72%
Total 25 100%

I want to represent all data in a pie chart, but when I select three
columns
and select Insert Pie Chart, it displays data in a weird way. For example
it
shows total as 50%, Product 1 as 14% and Product 2 as 36%. Which is the
correct way to do it, so as to display real values?

Thanks in advance

Regards,
Emece.-