Line graph question

  • Thread starter Thread starter WH99
  • Start date Start date
W

WH99

How do I get my date axes (the horizontal axes) to start at zero followed by
the first day of the month.
 
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
 
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
 
Thanks Jon, I shall try that.
--
WH99


Jon Peltier said:
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
_______
Click to expand...
 
Back
Top