vba chart unit spacing

[Kaps_mr2]

hello,

How do i set the unit spacing on a radar chart using vba ? I have the following but it gives an error on the line in orange - saying "method majorunit failed."

With ch
        .ChartType = xlRadar
        .HasTitle = True
        .ChartTitle.Text = sheet_name
        .ChartTitle.Font.Size = 12
        .ChartArea.Format.Line.Visible = msoFalse
        .Legend.Position = xlLegendPositionLeft
        .Axes(xlValue).MinimumScale = 0
        .Axes(xlValue).MaximumScale = 5
     [COLOR=rgb(247, 218, 100)]   .Axes(xlCategory, xlPrimary).MajorUnit = 1[/COLOR]
        
        
    End With

thanks
kaps

 

[bobsan42]

It seems that MajorUnit is only available for the Radar/Value axis, and not for the Category Labels.