How do i customise the plot area of a graph?
 

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 ?

How do i customise the plot area of a graph?
 

Hi,

This should work in xl2007,
http://peltiertech.com/Excel/ChartsH...orizBands.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jo D" <Jo wrote in message
...
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 ?