Add year date to x axis - Excel 2003 stacked column chart

  • Thread starter Thread starter jayrodz77
  • Start date Start date
J

jayrodz77

I am trying to add 2002 -2005 dates to the horizontal x axis of a
Stacked Column Chart in Excel.
It either comes out as 1 2 3 4 or 1900 (x four times). Can anyone help
please?
 
I am trying to add 2002 -2005 dates to the horizontal x axis of a
Stacked Column Chart in Excel.
It either comes out as 1 2 3 4 or 1900 (x four times). Can anyone help
please?
Click to expand...

If the Years are on the sheet, say range Sheet1!$A$1:$A$4, then select
the chart, pull down the Chart menu, select Source Data, select the
Series tab of the Source Data dialog, either type =Sheet1!$A$1:$A$4
into the "Category (X) axis labels:" text box or use the button to
collapse the dialog then select the cells with the X axis labels,
click OK.

If the Years are not on the sheet then you can type
={2002,2003,2004,2005} into the "Category (X) axis labels:" text box.

Ken Johnson
 
Back
Top