Advanced Formatting of Plot Area on XY Scatter Chart (Excel 2000).

[anniemalec]

Hi,

I was just wondering if anybody knew of a way I could format the colouring of the plot area of an xy chart on Excel 2000.

I'm aware of how to change the colour of the whole plot area, however I am looking to use 3 different colours to highlight whereabouts someones score point lays - i.e. underperforming 0-10 (red), achieving 11-20 (white), exceeding 20-24 (green).

Is this at all possible and if so, please could someone advise me how.

Thanks very much.

 

[anniemalec]

???