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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jayrodz77@hotmail.com - 30 Mar 2008 21:38 GMT

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?

Reply to this Message

Ken Johnson - 31 Mar 2008 00:45 GMT

On Mar 31, 7:38 am, jayrod...@hotmail.com wrote:

> 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?

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

Reply to this Message

Rate this thread: