Area Chart combined with Line Chart

[Guest]

I've been trying to chart two sets of data. One in an area chart and then
adding line graphs on a second axis. Unfortunately, when I click on the data
that I want to change to a line, it all changes, or if I click from a line to
the area, it all changes. Is this a quirck with the area charts?

 

[Jon Peltier]

Make sure you select the particular series in the chart that you want to
change, then do Chart menu > Chart Type.

- Jon

 

[Guest]

I did, but it simply changes everything to a line or area chart. I thought
maybe it was some kind of glitch with the area chart or maybe it is that I
have four sets of data and I want 2 and 2?

 

[Jon Peltier]

Is it a 2D or 3D chart? 3D charts don't allow combinations of chart types
within a single chart.

- Jon

 

[Guest]

What an idiot. Of course. Thanks so much.