Excel Scatter chart

[bexley]

Good morning everyone,

We have a risk register and want to create a scatter chart with th
risk scores.az
This works fine but here comes the complicated bit. I would like th
background to have three different colour and to represent the thre
areas of risk and this should be per number. i.e under axis y 1 and axi
x 2 the colour of the square should be green, under axis 2 and axis
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 custome chart which would already have th
background with all colours and squares. Is that at all possible t
achieve?

I would be grateful if you could help me as I am desperate

 

[Harlan Grove]

We have a risk register and want to create a scatter chart with the
risk scores.az
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 custome chart which would already have the
background with all colours and squares. Is that at all possible to
achieve?

....

This is definitely the wrong newsgroup in which in which to be asking
technical questions about specific office applications. You should ask
this in an Excel-specific newsgroup, in this case either

microsoft.public.excel

microsoft.public.excel.charting

microsoft.public.excel.misc