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,
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks