Line graph question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WH99 - 26 May 2008 13:29 GMT

How do I get my date axes (the horizontal axes) to start at zero followed by
the first day of the month.

Signature

WH99

Reply to this Message

ShaneDevenshire - 26 May 2008 22:50 GMT

Hi,

If your dates are entered in the spreadsheet as dates then you may have
problems - Excel stores dates as numbers so today is 39594 and 0 would be
January 0, 1900. This would tend to spread the x-axis out quite a ways. If
your dates are not entered as dates then make the first entry 0,0 - that is
put another entry in the data area whose date value is 0 and whose value is
0. There are potential problems with this approach - each entry will be
spaced equidistant apart on the x-axis, but that may work for you.

Cheers,
Shane Devenshire

> How do I get my date axes (the horizontal axes) to start at zero followed by
> the first day of the month.

Reply to this Message

Jon Peltier - 27 May 2008 00:49 GMT

You could just place the day number into a range next to the dates, use this
as the X values, and create an XY chart. The X axis of the XY chart is a
value axis which you can format to start at 0.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

> How do I get my date axes (the horizontal axes) to start at zero followed
> by
> the first day of the month.

Reply to this Message

WH99 - 27 May 2008 09:41 GMT

Thanks Jon, I shall try that.

Signature

WH99

> You could just place the day number into a range next to the dates, use this
> as the X values, and create an XY chart. The X axis of the XY chart is a
[quoted text clipped - 10 lines]
> > by
> > the first day of the month.

Reply to this Message