View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
John Mansfield John Mansfield is offline
external usenet poster
 
Posts: 235
Default multiple colors on format of plot area

You can do so by bringing a stacked column chart into the mix.

Please see Jon's example below:

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

--
John Mansfield
http://cellmatrix.net





"BillO" wrote:

How can I change the format of the plot area to multiple colors.

for example I would like to have a Bar Chart with the background plot area
starting @ blue , then Green, then Red. Then have the temperature bars
plot over this area.

thanks