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?

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

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


"jmrd" wrote in message
...
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?

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" wrote:

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

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


"jmrd" wrote in message
...
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?

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

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


"jmrd" wrote in message
...
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" wrote:

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

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


"jmrd" wrote in message
...
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?

What an idiot. Of course. Thanks so much.

"jmrd" wrote:

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?