Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dan
 
Posts: n/a
Default showing percentages in pie charts

I've created some pie charts, and they work fine, but I need to change the
percentages to display more granularly by increasing decimal positions.
There are a number of items showing as 0% when in fact they might be .25% or
..33%, and for this particular application I need to be able to show that,
and so far can't find the answer.

Thanks,

Dan

--


-------------------------------------------------------------------------
FIGHT BACK AGAINST SPAM!
Download Spam Inspector, the Award Winning Anti-Spam Filter
http://mail.giantcompany.com



  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi Dan,

Double click the data labels and on the Number tab increase the decimal
places.

Cheers
Andy

Dan wrote:
I've created some pie charts, and they work fine, but I need to change the
percentages to display more granularly by increasing decimal positions.
There are a number of items showing as 0% when in fact they might be .25% or
.33%, and for this particular application I need to be able to show that,
and so far can't find the answer.

Thanks,

Dan


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Dan
 
Posts: n/a
Default

Terrific. Worked like a charm. Thanks Andy.

--


-------------------------------------------------------------------------
FIGHT BACK AGAINST SPAM!
Download Spam Inspector, the Award Winning Anti-Spam Filter
http://mail.giantcompany.com


"Andy Pope" wrote in message
...
Hi Dan,

Double click the data labels and on the Number tab increase the decimal
places.

Cheers
Andy

Dan wrote:
I've created some pie charts, and they work fine, but I need to change
the percentages to display more granularly by increasing decimal
positions. There are a number of items showing as 0% when in fact they
might be .25% or .33%, and for this particular application I need to be
able to show that, and so far can't find the answer.

Thanks,

Dan


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info



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 remove empty chart plots from linked worksheet charts Lee IT Charts and Charting in Excel 3 January 31st 05 04:31 PM
initial size of new charts bob m Charts and Charting in Excel 1 January 22nd 05 02:19 AM
To get a lot of charts that contain different values in a minute Kevin Charts and Charting in Excel 0 December 28th 04 06:45 AM
pie charts - how to include "zero" fields on Legends Doug VanOrnum Charts and Charting in Excel 0 November 30th 04 04:49 PM
Macro for multiple charts JS Excel Worksheet Functions 1 November 19th 04 03:44 AM


All times are GMT +1. The time now is 07:33 AM.

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"