Change Word/Excel Pie Chart Total

[Christopher Chung]

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

 

[USAFRet]

A pie chart shows a percentage. What percent does each value take up, out of 100%

What are you trying to show?

 

[Christopher Chung]

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.

 

[USAFRet]

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.

 

[Christopher Chung]

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.