Stop dates on x axis plotting chronologically

  • Thread starter Thread starter diane
  • Start date Start date
D

diane

I'm sure i have seen this problem on the newsgroup before
but couldn't find the solution, so apologogies to
everybody but...

I'm trying to plot comparative annual data on a stacked
bar chart, my data is set out as:

jan03 jan04 feb03 feb04 and so on and I want the x
axis to reflect this order, what it does instead is:

jan03 feb03 jan04 feb04

How do I get the data series in the order that I've
entered it on the worksheet?

Thanks in advance

Diane
 
With the chart selected, select Chart | Chart Options... | Axes tab.
In there, for the Category (X) Axis, set the option to 'Category'
rather than 'Automatic' or 'Time-Scale'

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top