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 ?

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" <Bob wrote in message
...
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 ?

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

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

"Bob Smith" wrote:

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 ?