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

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


"WH99" wrote:

How do I get my date axes (the horizontal axes) to start at zero followed by
the first day of the month.
--
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
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
_______


"WH99" wrote in message
...
How do I get my date axes (the horizontal axes) to start at zero followed
by
the first day of the month.
--
WH99

Thanks Jon, I shall try that.
--
WH99


"Jon Peltier" wrote:

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
_______


"WH99" wrote in message
...
How do I get my date axes (the horizontal axes) to start at zero followed
by
the first day of the month.
--
WH99