I have a macro to set up the source data for a Piechart as below

With Worksheets("Summary_report").chartobjects(9).chart
.setsourcedata source:=range(range_string), plotby:=xlcolumn
end with
The range_string is constructed by the macro before. As this is a Pie chart
the range is a single column only but the range values are not contiguous.
Similarly I want to set the category labels also programmatically but unable
to find a suitable method / property in Chart object that will achieve this.
The chartwizard method has an optional variant "categorylabels" but does not
seem to work for Pie chart. Any help would be greatly appreciated

Thanks, Sesh