I have a combination chart: line and area series on the secondary axis (used
as a background), column series on the primary axis (used as a foreground).
The lines are plotting on top of the columns - wheather the lines are on the
primary or secondary axis makes no difference. How do I get the column on
top of the lines (bring to front)?
Thanks, Phil

Excel doesn't let you change the layering of different chart types in a
chart. Line and XY series always plot in front of column series, and
columns in front of areas.

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


Phil Hageman wrote:

> I have a combination chart: line and area series on the secondary axis (used
> as a background), column series on the primary axis (used as a foreground).
> The lines are plotting on top of the columns - wheather the lines are on the
> primary or secondary axis makes no difference. How do I get the column on
> top of the lines (bring to front)?
> Thanks, Phil

I believe this just solved a dilemna I've been struggling with. A coworker
created a column and line chart using 4 data sets. Then wanted to convert one
o fteh lines back to a column. The conbversion was no problem, however the
resultant column appeared in front of the origianl columns, covering one data
element. I presume this is because the line element, even when changed to a
column type, remains on the "top" layer. Have I understood your explanantion
correctly?

My solution to the issue is to recreate teh chart as a pure column chart,
then convert the one desired element into a line type. Is there a better
solution to this situation?

Thanks

"Jon Peltier" wrote:

> Excel doesn't let you change the layering of different chart types in a
> chart. Line and XY series always plot in front of column series, and
> columns in front of areas.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> Phil Hageman wrote:
>
> > I have a combination chart: line and area series on the secondary axis (used
> > as a background), column series on the primary axis (used as a foreground).
> > The lines are plotting on top of the columns - wheather the lines are on the
> > primary or secondary axis makes no difference. How do I get the column on
> > top of the lines (bring to front)?
> > Thanks, Phil
>

Hi,

If the converted column series appear above the other columns it is
because they are on different axis.
Double click the column and on the Axis tab set it to the primary axis.

Cheers
Andy

JR Hester wrote:
> I believe this just solved a dilemna I've been struggling with. A coworker
> created a column and line chart using 4 data sets. Then wanted to convert one
> o fteh lines back to a column. The conbversion was no problem, however the
> resultant column appeared in front of the origianl columns, covering one data
> element. I presume this is because the line element, even when changed to a
> column type, remains on the "top" layer. Have I understood your explanantion
> correctly?
>
> My solution to the issue is to recreate teh chart as a pure column chart,
> then convert the one desired element into a line type. Is there a better
> solution to this situation?
>
> Thanks
>
> "Jon Peltier" wrote:
>
>
>>Excel doesn't let you change the layering of different chart types in a
>>chart. Line and XY series always plot in front of column series, and
>>columns in front of areas.
>>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>Peltier Technical Services
>>Tutorials and Custom Solutions
>>http://PeltierTech.com/
>>_______
>>
>>
>>Phil Hageman wrote:
>>
>>
>>>I have a combination chart: line and area series on the secondary axis (used
>>>as a background), column series on the primary axis (used as a foreground).
>>>The lines are plotting on top of the columns - wheather the lines are on the
>>>primary or secondary axis makes no difference. How do I get the column on
>>>top of the lines (bring to front)?
>>>Thanks, Phil
>>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks, that certainly did the trick. There is still so much to learn!

"Andy Pope" wrote:

> Hi,
>
> If the converted column series appear above the other columns it is
> because they are on different axis.
> Double click the column and on the Axis tab set it to the primary axis.
>
> Cheers
> Andy
>
> JR Hester wrote:
> > I believe this just solved a dilemna I've been struggling with. A coworker
> > created a column and line chart using 4 data sets. Then wanted to convert one
> > o fteh lines back to a column. The conbversion was no problem, however the
> > resultant column appeared in front of the origianl columns, covering one data
> > element. I presume this is because the line element, even when changed to a
> > column type, remains on the "top" layer. Have I understood your explanantion
> > correctly?
> >
> > My solution to the issue is to recreate teh chart as a pure column chart,
> > then convert the one desired element into a line type. Is there a better
> > solution to this situation?
> >
> > Thanks
> >
> > "Jon Peltier" wrote:
> >
> >
> >>Excel doesn't let you change the layering of different chart types in a
> >>chart. Line and XY series always plot in front of column series, and
> >>columns in front of areas.
> >>
> >>- Jon
> >>-------
> >>Jon Peltier, Microsoft Excel MVP
> >>Peltier Technical Services
> >>Tutorials and Custom Solutions
> >>http://PeltierTech.com/
> >>_______
> >>
> >>
> >>Phil Hageman wrote:
> >>
> >>
> >>>I have a combination chart: line and area series on the secondary axis (used
> >>>as a background), column series on the primary axis (used as a foreground).
> >>>The lines are plotting on top of the columns - wheather the lines are on the
> >>>primary or secondary axis makes no difference. How do I get the column on
> >>>top of the lines (bring to front)?
> >>>Thanks, Phil
> >>
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>