How do i customise the plot area of a graph?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jo D - 23 Jan 2008 01:48 GMT

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 ?

Reply to this Message

Andy Pope - 23 Jan 2008 10:42 GMT

Hi,

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

Cheers
Andy

Signature

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

> 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 ?

Reply to this Message