View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Can you change the # of places for percentages in xcel charts

Hi,

Select the cells you want formatted and click the Increase Decimals button
on the Formatting toolbar as many times as necessary.

--
Cheers,
Shane Devenshire


"Headmistress05" wrote:

I have some data that = less than 1% of the total amount, and want to display
it as 0.xxx instead of "0" percent. Is there a way to change the percentage
format to include more than one # place?