Can you change the # of places for percentages in xcel charts

H

Headmistress05

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?
 
S

ShaneDevenshire

Hi,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Labeling on independently stacked line chart 0
adding percentages to stacked bar charts 1
Pie Chart percentage 1
MS Project. Real progress of the project, % complete 1
Percentages in a pie chart 3
Percentages Total 3
Chart percentage display needs to be neater 1
Requesting help to generate progress reports in Excel ... 0

Top