I cannot reproduce this problem unless I add dates both before and after the
dates with actual data and include this extended range in the graph. You may
want to check and adjust the range plotted...or, as already suggested, adjust
the min and max values of the corresponding axis so that the plotted range is
restricted to that with data in it. When entering the new min. and max.
values you can specify the value as a date (1/1/2009, for example).

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"David Moye" wrote:

When I create an area chart from with a date range as the x-axis, there are
diagonals that take the chart to the data value for the first day, and from
the last data value down to the axis. What I would prefer are verticals as
the diagonals sure make it look like the chart has ended with a 0 y-axis
value, or starts with a 0 y-axis value. Any ideas?