 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / September 2007formatting a percentage figure = 0%, 0.0%
Created a Pie chart with slices representing percentages, my question is about formatting the %, which should look like this 0.0% Sequence I tried was to double click on chart to get the correct menu bar/ribbon | Format | Number | Percentage | Custom | 0.0% (i.e. 78.5%) but what I get is 7850%. Thanks Hi, The old percent decimal place trick! Make sure you do this from within PowerPoint (2007). Right click on one of the data labels on your Pie Chart within PowerPoint. Select Format Data Labels. When the dialog box pops up, go to the Number option on the left. Select the number category Percent, and type into the Decimal places box the number 1. You will get a percent with one decimal to place.  SignatureRegards, Glen Millar Microsoft PPT MVP Tutorials and PowerPoint animations at the original www.pptworkbench.com glen at pptworkbench dot com ------------------------------------------ PPTLive! Oct 28-31, New Orleans http://www.pptlive.com Come and say "G'Day" to the Aussie! > Created a Pie chart with slices representing percentages, my question is > about formatting the %, which should look like this 0.0% > Sequence I tried was to double click on chart to get the correct menu > bar/ribbon | Format | Number | Percentage | Custom | 0.0% (i.e. 78.5%) but > what I get is 7850%. > Thanks Tried that aswell it didn't work. My breakdown should look like 3.5%, 18% and 78.5%... > Hi, > [quoted text clipped - 15 lines] > > what I get is 7850%. > > Thanks Hi, I can see your problem with the technology. However, from my graphing experience, I'm not sure it is valid to mix up the number of decimal places in data! That is, I'm not sure you can go to zero decimal place accuracy with some data, and then one decimal place accuracy with other data. So, your 18% should be 18.0% because that is the level of accuracy of your other data. SignatureRegards, Glen Millar Microsoft PPT MVP Tutorials and PowerPoint animations at the original www.pptworkbench.com glen at pptworkbench dot com ------------------------------------------ PPTLive! Oct 28-31, New Orleans http://www.pptlive.com Come and say "G'Day" to the Aussie! > Tried that aswell it didn't work. My breakdown should look like 3.5%, 18% > and [quoted text clipped - 22 lines] >> > what I get is 7850%. >> > Thanks I'll edit individually on that particular percentage - my main problem is the current format of 78.5% (adjusting the format as above with and without the decimal point) looks like 7850% or 7850.0% - strange, no!? > Hi, > [quoted text clipped - 32 lines] > >> > what I get is 7850%. > >> > Thanks In the data sheet, type your data like this: .785 That is 78.5% and will show up as 78.5% on the chart. SignatureEcho [MS PPT MVP] http://www.echosvoice.com What's new in PPT 2007? http://www.echosvoice.com/2007.htm Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/ > I'll edit individually on that particular percentage - my main problem is > the [quoted text clipped - 45 lines] >> >> > what I get is 7850%. >> >> > Thanks It worked!! Thank you so much - I was about to manually edit 2 worksheets > In the data sheet, type your data like this: .785 That is 78.5% and will > show up as 78.5% on the chart. [quoted text clipped - 48 lines] > >> >> > what I get is 7850%. > >> >> > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.