Chart-date axis format

[Bob Ptacek]

I am using date-times as the x axis. The differences between two point is not
always the same. Could be 3 days, 8 days etc. But the data axis formats are
in day order day 1, 2, 3, 4 etc.. I can't seem to modify teh axis format
correctly to get what I need. What format option can I set so that if I have
3 data points on day 1, 5 and 15 that I have 3 dates on the x axis instead of
the 15 I get by default.

Thanks in advance for any hints/help

 

[Bernard Liengme]

Right click the chart; select Chart Options
On the Axes tab; chance the Primary axis from Automatic (or Time Series) to
Category
best wishes

 

[Bernard Liengme]

If using XL2007:
1 right click the x-axis; use Format Axis
2 select Axis Options on the left side of dialog
3 in right side of dialog; click the box for Axis Type Text
best wishes

 

[Bob Ptacek]

Thank you that did the trick.

Right click the chart; select Chart Options
On the Axes tab; chance the Primary axis from Automatic (or Time Series) to
Category
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email