How to keep specific bar color in chart when the bar change position in chart (conditional bar color)

[Manojlo]

Hello

Is there any options to add specific color for single bar in chart, and bar to keep this color when change position in chart.

For Example if we have two columns A i B, in A column (from A2:A5) we have words: Red, Blue, White, Yellow and Green, and in B column we have some values: 10, 20, 30, 40 and 50.
We make Clustered column chart in descending order, for example Green cell is on first place and have value 50, and I want to make this bar in green color even if I change values, for example 10 and it is not on first place anymore

 

[onlyadrafter]

Hello,

can be done with code

Sub COLOUR_GRAPH()
    ActiveSheet.ChartObjects("Chart 1").Activate
    For MY_ROWS = 2 To 6
        ActiveChart.SeriesCollection(1).Points(MY_ROWS - 1).Select
            With Selection.Interior
                Select Case Range("A" & MY_ROWS).Value
                    Case "Red"
                        MY_COLOUR = 3
                    Case "Yellow"
                        MY_COLOUR = 6
                    Case "White"
                        MY_COLOUR = 2
                    Case "Blue"
                        MY_COLOUR = 5
                    Case "Green"
                        MY_COLOUR = 10
                End Select
        .ColorIndex = MY_COLOUR
        .Pattern = xlSolid
            End With
    Next MY_ROWS
End Sub

could be added to a worksheet change event.