X Axis units in Excel Graph

[GenesFISHer]

I need to have the X axis units be years

i.e. 2002 2003 2004 2005 2006 2007

Any help would be greatly appreciated.

 

[Bob Greenblatt]

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?

 

[BG]

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° ...

 

[Laroche J]

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

 

[Michel]

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?
[/QUOTE]
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.

 

[Carl Witthoft]

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.