If the cells for 1962 in presidential years are blank, select the chart,
choose Options from the Tools menu, and on the Chart tab, for Chart Empty
Cells As, choose Interpolated.

If the cells contain a formula that returns "" for the in between years,
which is not a blank, change "" to NA() in the formula. This puts an ugly
#N/A error in the cell (use conditional formatting to hide the error), but
it results in a line from the 1960 to the 1964 point.

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


"Max Daniel" wrote in message
...
I am trying to make a chart with two series--one showing turnout in
presidential years and the other in mid-term elections.

In the first column I put the year (1960, 1962, 1964). In the second
column I put voter turnout in presidential years (1960, 1964). In column
three in put voter turnout in mid-term elections (1962, 1966). I select
all the data. The problem is in presidential years the data goes from, for
example, 60% in 1960 down to zero in 1962 before going back to 60% in
1964. I want the data line to go directly from 1960 to 1964 without
dropping to zero in between. Can anybody tell me how to do this? Thanks

--
Max Daniel