Z-order Plotting Area

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