Chart Date X Axis
 

I currently have a chart with an x axis that is dates. The dates aren't
in order in the supporting table but display in order on the chart which
is great.

Is there a way of appending some text to each date field and having the
date and text displayed on the x axis and having Excel order the dates
in chronological order.

ie in the table
10 Apr 04-1
15 Feb 04-5
20 May 04-2
31 Jan 04-4
would still print in date order.
Thanks...

MrC wrote:

I currently have a chart with an x axis that is dates. The dates aren't
in order in the supporting table but display in order on the chart which
is great.

Is there a way of appending some text to each date field and having the
date and text displayed on the x axis and having Excel order the dates
in chronological order.

ie in the table
10 Apr 04-1
15 Feb 04-5
20 May 04-2
31 Jan 04-4
would still print in date order.
Thanks...
Sorry,
"would still print in date order"
should say
"would display in date order along the x axis of the chart"

Excel uses the values as dates if it recognizes their date format. As
soon as you append text, their format is no longer a date, and you lose
the ability to sort by date order.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

MrC wrote:

I currently have a chart with an x axis that is dates. The dates aren't
in order in the supporting table but display in order on the chart which
is great.

Is there a way of appending some text to each date field and having the
date and text displayed on the x axis and having Excel order the dates
in chronological order.

ie in the table
10 Apr 04-1
15 Feb 04-5
20 May 04-2
31 Jan 04-4
would still print in date order.
Thanks...