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 (E-Mail Removed)> wrote in message
news:82B9E3AD-E6C4-44D6-91C0-(E-Mail Removed)...
> 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 ?
>