Change Word/Excel Pie Chart Total

Christopher Chung

Honorable
Dec 17, 2013
3
0
10,510
0
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

Illustrious
Moderator
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

Honorable
Dec 17, 2013
3
0
10,510
0

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

Illustrious
Moderator
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

Honorable
Dec 17, 2013
3
0
10,510
0


Thanks again! I didn't think of that, I will choose value and put the formula back in the cells.
 
Thread starter Similar threads Forum Replies Date
R Apps General Discussion 2
Aksheev Apps General Discussion 4
L Apps General Discussion 2
F Apps General Discussion 6
M Apps General Discussion 1
U Apps General Discussion 1
F Apps General Discussion 3
M Apps General Discussion 4
M Apps General Discussion 7
C Apps General Discussion 2
B Apps General Discussion 8
Z Apps General Discussion 10
RepoDraghon Apps General Discussion 1
Z Apps General Discussion 3
B Apps General Discussion 1
U Apps General Discussion 1
M Apps General Discussion 1
indyitguy Apps General Discussion 7
A Apps General Discussion 1
M Apps General Discussion 1

ASK THE COMMUNITY