This web page describes a technique, which could probably be adjusted to
give the OP the desired effect:

http://peltiertech.com/Excel/Charts/...ticalBand.html


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Andy Pope" wrote in message
...
Hi,

If you want colour banding on the plot area you can produce this effect by
adding 3 dummy series and plotting them as stacked column.
The values for each point in each series will be 2% , 2% and 1%.
Format the columns to be the correct colours also remove the border.
On the Format dialogs Options tab set the Gapwidth to 0.

Cheers
Andy

TonyU1234 wrote:
For instance, if I have a single series chart with Y axis from 0% to 5%,
how do I put a red color from 0 to 2%, green from 2 to 4% and blue from 4
to 5%?

--

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