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,

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

Geert Porteman wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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

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

Geert Porteman wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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

Cheers
Andy

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


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

Geert Porteman wrote:

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, Microsoft MVP - Excel
http://www.andypope.info


--

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