 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / May 2008X Axis units in Excel Graph
I need to have the X axis units be years i.e. 2002 2003 2004 2005 2006 2007 Any help would be greatly appreciated. On 2/9/08 3:02 PM, in article 4f58989a-5d93-4be6-91ec-1b474e2a366d@m34g2000hsf.googlegroups.com, > I need to have the X axis units be years > > i.e. 2002 2003 2004 2005 2006 2007 > > Any help would be greatly appreciated. You need to be more specific. What are you doing that is not working? Are your values in the data table dates? How are they formatted? What is showing (not showing) on your chart?  SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom I'm sure its easy once I get to understand the logic of the new chart system, but I want my X-axis labels for my line chart to be at a 45-degree angle to the axis. This used to be easy, but I can't find it anywhere, nor on the forums. I know it can be done, because the example in the help file shows them at a 45° ... BG wrote on 2008-03-30 12:57: > I'm sure its easy once I get to understand the logic of the new chart system, > but I want my X-axis labels for my line chart to be at a 45-degree angle to > the axis. This used to be easy, but I can't find it anywhere, nor on the > forums. I know it can be done, because the example in the help file shows them > at a 45° ... Select the X-axis, go to Format / Selected Axis, then to the Alignment tab. JL Mac OS X 10.4.11, Office v.X 10.1.9 > On 2/9/08 3:02 PM, in article > 4f58989a-5d93-4be6-91ec-1b474e2a366d@m34g2000hsf.googlegroups.com, [quoted text clipped - 12 lines] > Bob Greenblatt [MVP], Macintosh > bobgreenblattATmsnDOTcom Hope you're still reading this thread. Already 3 months since your explanation, but I see many similar questions and no clear answer. I just want to make a simple graph with data against years (x-axis). I cannot put in the x-axis data as years only, but need to input like 1-1-2008 etc. otherwise the date format will turn it into 1905 dates. When having the graph made, the dates are correctly used as x-axis data, but still in their full format (1-1-2008) where I just need 2008. If I use a 1-januari-2008 notation (I'm using the Dutch version of Excel 2008) the graph tool will use the English notation instead. Even I cannot find a tool for manually editing the x-axis data (Y-axis legend is OK). Any help appreciated. > > On 2/9/08 3:02 PM, in article > > 4f58989a-5d93-4be6-91ec-1b474e2a366d@m34g2000hsf.googlegroups.com, [quoted text clipped - 24 lines] > notation instead. Even I cannot find a tool for manually editing the x-axis > data (Y-axis legend is OK). Any help appreciated. Unless office2008 borked this, it's easy: on the chart, click on the X-axis. Select the menu Format/Selected Axis . In the dialog box, click the Number tab, then select the format you want displayed on the chart. SignatureTeam EM to the rescue! http://www.team-em.com |
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.