|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
01-28-2005, 08:06 AM
|
|||
|
|||
|
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
01-28-2005, 08:06 AM
|
|||
|
|||
|
Re: showing percentages in pie charts
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
01-28-2005, 11:06 AM
|
|||
|
|||
|
Re: showing percentages in pie charts
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" <andy@andypope.info> wrote in message news:eHd9v2SBFHA.2012@TK2MSFTNGP15.phx.gbl... > 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
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
