Changing Category (x) axis labels for radar charts

B

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 ?
 
P

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
 
B

Bob Smith

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel automation, change Category (X) Axis Labels, VB6 1
chart x axis labels show up as range 1
Setting the category Label source for a Pie chart 1
Pivot Chart - X-axis labels when adding data 0
How do I modify charts thorugh VB 9
Excel Problem with x axis labels in Excel 2010 chart 2
Named Ranges for Chart 1
Category (X) Axis Labels not found in Excel 2003 2

Top