Comumn Series Brought to Front

P

Phil Hageman

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
 
J

Jon Peltier

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/
_______
 
J

JR Hester

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top