View Single Post
  #1   Report Post  
MrC
 
Posts: n/a
Default 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...