Pie chart incorrect
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?
I'd need to see how your data is laid out. Can you upload an example spreadsheet/pie chart?
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
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
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.
% is of total
i.e
303.45
1797.00 +
=
2100.45
so
303.45/2100.45 % = 14.4469
thats why
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
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%
Thank you folks. Now I understand. Where would I be without you all?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks