Hi Everyone,

I have a risk register and want to create a scatter chart with the risk
scores.This works fine but here comes the complicated bit. I would like the
background to have three different colour and to represent the three areas of
risk and this should be per number. i.e under axis y 1 and axis x 2 the
colour of the square should be green,under axis 2 and axis 3 the colour of
the square should be amber ...
I have tried to format the chart area but it colours the whole chart.
I thought of creating a custom chart which would already have the background
with all colours and squares. Is that at all possible to
achieve?

Any help would be great as I am really desperate to find a solution.

Many thanks

Hi,

See Jon's page
http://peltiertech.com/Excel/ChartsH...orizBands.html

Cheers
Andy

bexley wrote:

Hi Everyone,

I have a risk register and want to create a scatter chart with the risk
scores.This works fine but here comes the complicated bit. I would like the
background to have three different colour and to represent the three areas of
risk and this should be per number. i.e under axis y 1 and axis x 2 the
colour of the square should be green,under axis 2 and axis 3 the colour of
the square should be amber ...
I have tried to format the chart area but it colours the whole chart.
I thought of creating a custom chart which would already have the background
with all colours and squares. Is that at all possible to
achieve?

Any help would be great as I am really desperate to find a solution.

Many thanks


--

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