line chart (version 2007)

[Enna]

I have asked this question before, but did not get any answers.
I have a line chart with dates (years of election) at the x-axis. The
percent could be e.g., National elections: 28% (1978), 41% (1982), 33%
(1986), and EP elections: 61% (1979), 59% (1984) 58% (1989). I want to
connect 28 with 41, 41 with 33 etc. with a line.
In version 2003 I coulc use the Tools menu > Options > Chart tab,
and in the top section, choose the Interpolate option for dealing with gaps.
But this feature does not exist in version 2007, at least I have not been
able to find it. How do I connect these plots, is it possible in any way
I do hope someone can help.
Enna

 

[Andy Pope]

Hi,

Select the chart and use Chart Tools > Design > Data > Select Data > Hidden
and Empty Cells

Cheers
Andy

 

[Enna]

Thank you so much. It works - great help - I use this feature so much.
Enna