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 |
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 |
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 |
All times are GMT +1. The time now is 04:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com