View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Multiple Colors on Area Charts

Hi

Have a look at Jon's page on horizontal bands.
http://peltiertech.com/Excel/ChartsH...orizBands.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SarahR." wrote in message
...
I would like to know if it is possible to have two different colors in the
plotted area of an area chart. In the end, I would like to have the color
for numbers less than 0 be one color and greater than 0 be second color.
Thanks