Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I Change Column Width for only some rows in an Xcel WkSht cherokee Excel Discussion (Misc queries) 1 July 30th 06 01:22 AM
how do I change default decimal places? Jason Excel Discussion (Misc queries) 4 June 22nd 06 09:33 PM
Percentages on Charts lisapizza Charts and Charting in Excel 0 January 12th 06 02:31 PM
Xcel charts into Powerpoint Travis Charts and Charting in Excel 0 February 11th 05 05:11 AM
showing percentages in pie charts Dan Charts and Charting in Excel 2 January 28th 05 02:17 PM


All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"