Z-order Plotting Area

[Guest]

Hi,

How can I change the Z-order of objects in the plotting area?
I Added a rectangle, which was meant to appear in the background, but it
covers my data series.

Thanks,

 

[Andy Pope]

Hi,

All embedded objects within the chart will appear above the actual
charting layer.

Maybe you could produce the rectangular area using dummy data series.
What information does the rectangle relate to in the context of your chart?

Cheers
Andy

 

[Guest]

Hi,

After plotting the value lines, I created several horizontal rectagles from
Green (ideal values), over Orange (warning values) to Red (alert values).
My colored zones covered my value lines, and I don't know how to move them
to the background, although in the properties menu there seems to be a
possibility. However, it doesn't work.

Greetings,
Geert

 

[Andy Pope]

Have a look at Jon Peltier's example,
http://peltiertech.com/Excel/Charts/ColoredVerticalBand.html

Cheers
Andy