View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Excel chart, changing into sections to color

Do you want the lines or the background to change color?

Here are examples showing in principle how to change colors behind the
lines:

http://peltiertech.com/Excel/Charts/...tml#Background

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


"rrupp" wrote in message
...
I have a line chart. The user is dividing the chart, manually, with
verticle
lines. In one section, he wants the chart to be red, in the next section
he
wants it blue and the third section he wants it yellow. I think it's a
neat
concept but in trying everything I can think of, I'm not thinking it's
possible. The lines color cannot be changed mid-stream. Any thoughts??