ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Can you change the # of places for percentages in xcel charts (https://www.excelbanter.com/charts-charting-excel/193156-can-you-change-places-percentages-xcel-charts.html)

Headmistress05

Can you change the # of places for percentages in xcel charts
 
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?

ShaneDevenshire

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?



All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com