Solved

Change Word/Excel Pie Chart Total

How can I change a pie charts total? Each piece totaling 500 instead of 100. I tried adding a formula on each cell but it's still taking it out of 100.

Thanks
4 answers Last reply Best Answer
More about change word excel pie chart total
  1. A pie chart shows a percentage. What percent does each value take up, out of 100%

    What are you trying to show?
  2. USAFRet said:
    A pie chart shows a percentage. What percent does each value take up, out of 100%

    What are you trying to show?

    For example, the numbers below are out of 100, I want the numbers to be out of 200 or 500 etc. not out of 100.

  3. Best answer
    Right. This is kind of the point of a pie chart. What percentage is each slice. 100% = the whole thing.
    You can change the data labels to show each actual value, instead of the percentage.

    Right click on the pie, select Format Data Labels...choose Value instead of Percentage.
  4. USAFRet said:
    Right. This is kind of the point of a pie chart. What percentage is each slice. 100% = the whole thing.
    You can change the data labels to show each actual value, instead of the percentage.

    Right click on the pie, select Format Data Labels...choose Value instead of Percentage.


    Thanks again! I didn't think of that, I will choose value and put the formula back in the cells.
Ask a new question

Read More

Office Apps Microsoft Word Excel Word 2010 Office 2010 Formula