Chart with two types of lines

[fluencie]

I am plotting data from 2006 and now starting to plot data from 2007 in
a line chart. I would like the line from 2006 to be a solid line, and
the line from 2007 to be a dotted line. This is measuring the same
data, just in different years. When i try to add a different series,
the new line for 2007 appears, and the 2006 line disappears. I'm not
sure how I get both of them to appear at the same time. Any idea what
I'm doing wrong?

B

 

[David Biddulph]

Have you checked Chart/ Source Data/ Series tab to see what you've got for
your two series?

It may also be worth thinking about whether it might be worth using XY graph
(confusing named scatter), rather than a line chart. This may depend on
whether you are wishing to plot your two Y data series against a dependent
parameter in an X series, or whether you merely have categories, rather than
values, against which to plot.

 

[Jon Peltier]

As David says, an XY chart may be the best way to get what you want.

If you use a line chart, you must remember that each series uses the same X
data as the first series, no matter what you try to impose. So to plot two
year you need to pad the data with blank cells (read with nonproportional
font):

2006 2007
2006Q1 X
2006Q2 X
2006Q3 X
2006Q4 X
2007Q1 X
2007Q2 X
2007Q3 X
2007Q4 X

- Jon