Does anyone know how to make a pie chart show decimal places in percentage instead of rounding the number up? Thanks
Does anyone know how to make a pie chart show decimal places in percentage instead of rounding the number up? Thanks
You can select the data labels and press the Increase Decimals toolbutton
or CTRL+1 to bring up the format dialog and on the Number tab set the decimals places for percent format.
Cheers
Andy
Thanks Andy. I was trying to do it by selecting the slice of the pie and not the number label itself. Thanks for pointing that out.