Patience wrote:
I am using Office 2003 (Excel) to create a line graph representing daily
ranking. However, there are several dates for which values are not available.
Is it possible to have Excel put a flat line in place of the missing values,
connecting only the available data?

Thanks,

---------------------

A couple of observations:

1) If you do not include the missing dates in your X data, then the
chart will do what you want.

2) Depending on what you're doing, I also sometimes will put an
interpolation formula into the missing Y cells to fill in the missing
data. When doing that I also change the formatting to a colored
background so that the interpolated data points are obvious.

Good luck...

Bill