How do i customise the plot area of a graph?

[Jo D]

In 2003 i customised a graph where the first 10% of the plot area was
coloured red, 10% to 80% amber and thent he rest green. This doesnt have to
be conditional but i cant find out how to do it in 2007. Any ideas ?

 

[Andy Pope]

Hi,

This should work in xl2007,
http://peltiertech.com/Excel/ChartsHowTo/HorizBands.html

Cheers
Andy