Question: how to calculate percentage in a pie chart in excel?
Answer: Add a pie chart to your report. ... 
On the design surface, right-click on the pie and select Show Data Labels. ... 
On the design surface, right-click on the labels and select Series Label Properties. ... 
Type #PERCENT for the Label data option.