Multiple colours in line chart background

  • Thread starter Thread starter Phillip Topping
  • Start date Start date
P

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
 
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)

Phillip said:
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
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top