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.
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.
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
_______
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
