Chart-date axis format

  • Thread starter Thread starter Bob Ptacek
  • Start date Start date
B

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
 
Right click the chart; select Chart Options
On the Axes tab; chance the Primary axis from Automatic (or Time Series) to
Category
best wishes
 
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
 
Back
Top