Excel 2002 SP2
Windows XP Pro

I'm trying to make a line chart showing data points of two series.

My X-axis labels are years, from 1970 through 2010.
My Y-axis labels are population values.

The first series (Series1) comes from actual data values in a column on
another sheet.

The second series (Series2) are calculated values that are in a column next
to the values for the first series.

Concerning just the first series:

First of all, for some reason the data points are appearing on the chart but
the line between points is not.

Secondly, and perhaps explaining the above, not every year value has a
population value. In these cases the cell for that particular year is blank
and does not contain a zero or any other value.

My aim is twofold, 1) to simply make a chart showing at least the Series1
data points with lines connecting the points, and 2) to try to impose a sort
of trendline between the first and last points that *must* pass through each
data point. I've managed to put some trendlines on the chart using Excel's
built in Trendline option, but they don't necessarily include the data
points. Is there a way to force a line that passes through all the data
points? Perhaps a trendline is a poor choice of words, maybe more like a
projection line.

Anyway, any help, suggestions or links would be greatly appreciated.

Thanks!

-gk-


=================================================
The creative act is not the province of remote oracles or rarefied geniuses
but a transparent process that is open to everyone.
-Greg Kot in Wilco Learning How To Die-