chart data line in two colors

[ReadyToLearn]

My boss wants a data line in my chart be green when abouve goal and red when
below goal. I do not think it is possable, but I thought I would check out
here first.

 

[Andrea Jones]

You could try making a second series column containing only the values that
are above target, leave the other cells blank. Check under Tools>Options in
the Chart section to make sure blank cells are not plotted and plot both
series, you should be able to get the 'above target' series to sit on top of
the 'all values' series and give it a different colour to achieve the effect
you want.

Andrea Jones

 

[Debra Dalgleish]

Andy Pope has instructions for a conditional line chart:

http://www.andypope.info/charts/conditionalline.htm