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" <(E-Mail Removed)> wrote in message
news:97307512-B47B-41CA-A290-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:97307512-B47B-41CA-A290-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news:CD56FAB4-4E74-413C-8078-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
>> news:97307512-B47B-41CA-A290-(E-Mail Removed)...
>> > 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?