A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Pie Chart



 
 
Thread Tools Display Modes
  #1  
Old April 1st, 2010, 04:43 PM posted to microsoft.public.excel.charting
Emece
external usenet poster
 
Posts: 106
Default Pie Chart

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.-
  #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.-



  #3  
Old April 1st, 2010, 05:49 PM posted to microsoft.public.excel.charting
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default Pie Chart

EXCEL 2007

You seem to have too many columns.

Take out the column that is not a percentage and I think things will work
out OK.

So you columns should look like:-

Column A should be your Products

Column B should be your Percentages

Please hit Yes if my comments have helped.

Thanks.



"Emece" wrote:

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.-

  #4  
Old April 1st, 2010, 05:50 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
 
Posts: 516
Default Pie Chart

Make the pie chart using just this data
Product 1 7
Product 2 18
Then format the chart to include data labels; you can display any/all of:
category names, data and percentage
Have a look at:
http://spreadsheets.about.com/od/exc...t_wiz_step.htm
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"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.-


  #5  
Old April 1st, 2010, 06:00 PM posted to microsoft.public.excel.charting
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default Pie Chart

EXCEL 2007

Check out:-

http://www.pierrefondes.com/

I have just put up your example: item 85 (towards the top of my home page
at the time of posting).

Please hit Yes if my comments have helped.

Thanks.

"Emece" wrote:

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.-

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.