Pie Chart

E

Emece

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

Luke M

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

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

trip_to_tokyo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pie chart areas reflect magnitude 5
Pie Charts 1
Pie Chart 1
Problem with pie chart 1
Basic Categorical Pie Chart Question 2
Pie Chart Percentage incorrect 8
Pie Chart - Columns 1
Pie Chart Troubles 1

Top