 |
 | 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 / Excel / Charting / August 2006hiding % characted in the Y axis using custom format
Few weeks ago I have seen a presentation where by using custom format it was possible to format the Y axis so that it was displaying the % only next to 100 and all the rest of the axis was displaying numbers without %. It was like 100% 80 60 40 20 0 I do not remember the syntax of this custom format. Can someone refresh my memory ? How it was done ? Regards Tony Sounds like someone but a textbox over the 100 to make it 100% best wishes  SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > Few weeks ago I have seen a presentation where by using custom format it > was [quoted text clipped - 13 lines] > > Tony If the values where plain numbers then try [>=100]General\%;General Cheers Andy > Few weeks ago I have seen a presentation where by using custom format it was > possible to format the Y axis so that it was displaying the % only next to [quoted text clipped - 11 lines] > > Tony SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info Thank you Andy, it is exactly what I was after. Regards, Tony > If the values where plain numbers then try > [>=100]General\%;General [quoted text clipped - 17 lines] > > > > Tony Hi Andy, I was a bit too quick with replying. It is still not exactly what I want. It is showing now: 100% 0.8 0.6 0.4 0.2 while I would like to have: 100% 80 60 40 20 Could you please help me more. Regards, Tony > If the values where plain numbers then try > [>=100]General\%;General [quoted text clipped - 17 lines] > > > > Tony I did say plain numbers, by which I meant not those being converted to percentages. The % in the number format not only adds the % sign it also multiplys the value by 100. I don't think you can lose the % sign with your data. You would need to use a helper column to factor up the values first. Maybe you could contact whoever gave the presentation and ask how they did it? Cheers Andy > Hi Andy, > [quoted text clipped - 40 lines] >>> >>>Tony SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info Hi Andy, I have what I wanted. I have created another column with percentage values multiplied by 100 and used the following custom format: [=100]General\%;General It is displaying now what I wanted. Regards, Tony > If the values where plain numbers then try > [>=100]General\%;General [quoted text clipped - 17 lines] > > > > Tony |
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.