I meant gaps in the worksheet. Blank cells.

You can change the way the chart treats blanks. By default it leaves a
gap in the chart (if it's truly a blank, no formula that returns "",
which only looks like a blank). Select the chart, go to Tools menu
Options Chart tab, and change the Plot Blanks As setting.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


namsilat wrote:
The example I tried so far has 7 dots, so there are 3 lines joining 2 dots
each, with final dot not connected. As for the distance between the dots,
that was the entire pooint of my original question. These are set up as
number of days, so not every day there is a data point. I was hoping Excel
would try to connect them in a smooth curve. The overall curve should look
like a parabola, I just need some graph linking it to make it presentable.