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