Color chart

[kyjak555]

hello can you help me?

if the value increases from the previous one, the graph turns blue and if it decreases to red.

 

[p45cal]

By VBA only I think. One way; this macro is run when you click the button at cell Z3:

Sub blah()
Set myPoints = Sheets("v.B KW CP").ChartObjects("Graf 1").Chart.FullSeriesCollection(1).Points
For i = 2 To myPoints.Count
  With myPoints(i).Format.Line
    If myPoints(i).Top > myPoints(i - 1).Top Then
      .ForeColor.RGB = RGB(255, 0, 0)
    Else
      .ForeColor.RGB = RGB(0, 112, 192)
    End If
  End With
Next i
End Sub

See https://peltiertech.com/conditional-formatting-of-lines-in-an-excel-line-chart-using-vba/

 

[vletm]

kyjak555
It can do without VBA too,

as shown in above link.​

Here a sample.

If You can get some nice formulas
- then those could get it with five series ( black bordered range ).

 

[kyjak555]

you are the Best

 

[kyjak555]

HI VLETM i need chart for all year from KW 1 to KW 52 can you do it?

 

[vletm]

kyjak555
Did You check - how did that was done?
Did You try to do it Yourself?

 

[kyjak555]

HI VLETM pls help me lines are not displayed

 

[vletm]

kyjak555
Lines will display after You have chosen Line from No line to Solid line

Your original sample has less data and
Your newer sample has more data.
... then it could do this way too.