X Axis units in Excel Graph

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° ...
 >> Stay informed about: X Axis units in Excel Graph 

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
 >> Stay informed about: X Axis units in Excel Graph 

> On 2/9/08 3:02 PM, in article
> 4f58989a-5d93-4be6-91ec-1b474e2a366d RemoveThis @m34g2000hsf.googlegroups.com,
> "GenesFISHer" wrote:
>
> > 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?
>
> --
> 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.
 >> Stay informed about: X Axis units in Excel Graph 

In article , Michel RemoveThis @officeformac.com
wrote:

> > On 2/9/08 3:02 PM, in article
> > 4f58989a-5d93-4be6-91ec-1b474e2a366d RemoveThis @m34g2000hsf.googlegroups.com,
> > "GenesFISHer" wrote:
> >
> > > 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?
> >
> > --
> > 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.


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.

--
Team EM to the rescue! http://www.team-em.com
 >> Stay informed about: X Axis units in Excel Graph