Changing Category (x) axis labels for radar charts

[Bob Smith]

Having difficulty assigning new labels for radar chart
Worksheets("R").ChartObjects("Chart 42").Chart.SetSourceData
Source:=Sheets("P").Range("C4:C40"), PlotBy:=xlColumns
works ok and the values change but I am lost as to how to change the
category x labels. Any suggestions ?

 

[Peter T]

s = Worksheets("P").Range("B4:B40").Address(, , xlR1C1, True)
Worksheets("R").ChartObjects("Chart 42").Chart.SeriesCollection(1).XValues =
s

change B4:B40 as appropriate

Regards,
Peter T

Change

 

[Bob Smith]

Found the solution, use multiple range selection in the line below

....Range("A4:A40,C4:C40").....