Change the units displayed on the value axis If your chart values consist of large numbers, you can make the axis text shorter and more readable by changing the display unit of the axis. For example, if the chart values range from 1,000,000 to 50,000,000, you can display the numbers as 1 to 50 on the axis and show a label that indicates that the units express millions.
In the Display units list, click the units you want or type a numeric value. To show a label that describes the units expressed, select the Show display units label on chart check box. On Apr 9, 3:24 am, Prashanth Banneni <[email protected]> wrote: > Hi All, > > Any help on this please. > > guess you understand the urgency. > > Thanks, > Prashanth > > > > ---------- Forwarded message ---------- > From: Prashanth Banneni <[email protected]> > Date: Thu, Apr 9, 2009 at 11:09 AM > Subject: Convert $900,000 to $900k in graph > To: [email protected] > > Hi Team, > > I have an urgent requirement. > > i have a graph whose y axis has revenue from $0 to $900,000, now i want to > remove the last 000 and show as $100K, $200K, $300K, $400K......$900K. > > Can any one let me know how to change it in the custom tab under Format > Axis. > > Need this help for a presentation this evening. > > Thanks in advance. > > Prashanth > Analyst- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
