Color Chartlines based on values

[Gerard Bemelmans]

An Excel Line-chart with target and real values over a certain period of time.
I try to achieve to color the line with values below target in red an above target in green.
The lines between above/below are made gray in the attached example.

Is it possible to color lines realy above/below target so it becomes a solid line of two colors?

Gerard

 

[Luke M]

Welcome to the forum!
In short, no.

With the line chart, there's no real "point" where the line is crossing that target, and so we can't split the line into 2 separate colors. You could easily color just points, or switch chart types (maybe a column chart?).

 

[Hui]

Gerard

Firstly, Welcome to the Chandoo.org Forums

Do any of the techniques presented at: http://chandoo.org/wp/2013/02/13/shaded-line-charts-excel/
help you?

 

[Hui]

You could also try the following technique:

With only a single line, increase the line thickness
Then set the Line Color to Gradient, Linear and 90 Degrees
Set the end colors to suit
Adjust the position of the Center point (White) to match the Target line