Excel chart, changing into sections to color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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