1
Changing decimal places on percentage data label
I have a pie chart containing data labels for Values and Percentages, i want to change my percentages to 0 decimal places. Does anyone know how i would do this?
I have tried to change the decimal places for the Values but that doesn't carry over to the percentages.
Thanks,
Dan
1 reply
-
The percentage option is a "quick" technique for adding percents to your charts - so there is little flexibility. The stronger solution means creating a calculation (with your chosen data format), adding it to your query and using it in the "labels" drop zone. Then change the data label on your pie chart to show "value" and not the predetermined "percentage".