Multiple colours in line chart background

[Phillip Topping]

Is it possible to vary the colouring of a line chart
background to indicate when values are inside a "risk
zone"??

An example of this: Scientific values between 60 and 80
are potentially dangerous to clients...if the values
exceed 80 they are definitely dangerous...how can I colour
these areas in different colours to reinforce to clients
that values exist within these ranges??

Sounds a bit like Star Trek doesn't it?? Yellow
alert...Red alert...

TIA
Phillip Topping

 

[Andy Pope]

Hi Phillip,

Take a look at Jon Peltier's example, you will need to modify it
slightly to check bands.
(http://www.geocities.com/jonpeltier/Excel/Charts/ColoredQuadrantBackground.html)

Is it possible to vary the colouring of a line chart
background to indicate when values are inside a "risk
zone"??

An example of this: Scientific values between 60 and 80
are potentially dangerous to clients...if the values
exceed 80 they are definitely dangerous...how can I colour
these areas in different colours to reinforce to clients
that values exist within these ranges??

Sounds a bit like Star Trek doesn't it?? Yellow
alert...Red alert...

TIA
Phillip Topping

--

Cheers
Andy

http://www.andypope.info