Pie chart incorrect

[sswood101]

I created a chart/graph that was too complicated for my boss to read, so he asked me to make a simple pie chart. When I did, the percentages it calculated were incorrect and, as a result, the pieces of the pie are wrong, too. It is simple math. What's wrong here? Does anyone know of a fix?

[ChemistB]

I'd need to see how your data is laid out. Can you upload an example spreadsheet/pie chart?

[Andy Pope]

perhaps you can tell us what data you fed the chart, what values it reported and why you think they are wrong.

An example workbook would be best

[sswood101]

I've attached a sample chart. If one does a simple percentage calculation, e.g. 303.45/1797, the result should be 16.88%. My chart indicates 14%. Same is true of the other chart on the worksheet.

[martindwilson]

% is of total
i.e
303.45
1797.00 +
=
2100.45
so
303.45/2100.45 % = 14.4469
thats why

[Andy Pope]

pie charts work out the % of the items as a total rather than item 1 as a percentage of item 2.

so that's 303.45/(303.45+1797.0) = 14.4%

[sswood101]

Thank you folks. Now I understand. Where would I be without you all?