Continuous Line

Hi. If I am creating a line chart with the following
data, is there a way that I can get the line chart to skip
the date with no data (6/10 in this case). I would want
the line to connect between 6/9 and 6/11 instead of having
a break in the line.

Date Yield
6/6 96%
6/7 97%
6/8 93%
6/9 90%
6/10
6/11 85%
6/12 99%

Thanks,
Mike.

go to tools(optionschart and select the way you want
skipped data to show
-----Original Message-----
Hi. If I am creating a line chart with the following
data, is there a way that I can get the line chart to
skip
the date with no data (6/10 in this case). I would want
the line to connect between 6/9 and 6/11 instead of
having
a break in the line.

Date Yield
6/6 96%
6/7 97%
6/8 93%
6/9 90%
6/10
6/11 85%
6/12 99%

Thanks,
Mike.
.