line chart (version 2007)

E

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
 
A

Andy Pope

Hi,

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

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top