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