Excel chart, changing into sections to color

[rrupp]

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??

 

[Jon Peltier]

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/ChartIndex.html#Background

- Jon

 

[Andy Pope]

Hi,

If you want the line to change colour at the mid points of a section
then one way would be to use additional data series with twice as many
data points. You will need to link to the original data points and
calculate via formula the new mid points.

See example chart and file I have created.
http://www.andypope.info/ngs/ng50.htm

Cheers
Andy