vba radar chart grid line color

[Kaps_mr2]

hello,

is it possible to set the colour of the gridlines on a radar chart using vba ? I can set the colour of the data line but not the gridlines. Thanks

kind regards
Kaps

 

[myall_blues]

Try this. Obviously set the RGB to whatever you need.

    With ActiveChart.Axes(xlValue).MajorGridlines
        .Format.Line.ForeColor.RGB = RGB(50, 20, 80)
    End With
    With ActiveChart.Axes(xlValue)
        .Format.Line.ForeColor.RGB = RGB(50, 20, 80)
    End With

 

[Kaps_mr2]

thanks - the majorgridlines did the trick.