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.
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'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.
Pie chart incorrect
Linear Mode
