Chart-date axis format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Ptacek - 15 Jan 2008 17:10 GMT

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

Reply to this Message

Bernard Liengme - 15 Jan 2008 18:42 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I am using date-times as the x axis. The differences between two point is
>not
[quoted text clipped - 8 lines]
>
> Thanks in advance for any hints/help

Reply to this Message

Bob Ptacek - 15 Jan 2008 23:15 GMT

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
[quoted text clipped - 12 lines]
> >
> > Thanks in advance for any hints/help

Reply to this Message

Bernard Liengme - 15 Jan 2008 18:48 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I am using date-times as the x axis. The differences between two point is
>not
[quoted text clipped - 8 lines]
>
> Thanks in advance for any hints/help

Reply to this Message