Add categorylabels in excel chart

Hi,

I don't understand how I can add CategoryLabels in an Excel chart.

I tried that :
Dim series As IChartSerie = chart.Series(0)
series.CategoryLabels = sheet.Range("A1:B2")

But it didn't work :(

Thanks,
thuric

Hi Thuric,

I am afraid. I was not able to reproduce the issue. The category Labels are set correctly. Here is the test sample that I used to test this issue

http://websamples.syncfusion.com/samples/XlsIO.Web/4.4.0.51/F58330/main.htm

Here is the code snippet that I used to set CategoryLabels

[VB .NET]

Dim serieOne As IChartSerie = chart.Series(0)
serieOne.Name = "Apple"

'Category Labels
serieOne.CategoryLabels = sheet.Range("A2:A12")

Here is the screenshot of the output:

CategoryLabel.png

Could you please take a look at the sample above and kindly let me know if you still find any problem, if not could you please modify this sample so that I can reproduce the issue. This would help me in investigating this issue further.

Thanks,
Melba

hi Melba,

I used
chart.ChartType = ExcelChartType.Radar_Filled
and not
chart.ChartType = ExcelChartType.Radar
and it works with the second one.

Perharps, I'm not using it the right way.

thanks

Hi Thuric,

Thanks for the update!

Kindly let me know if you have any other questions.

Regards,
Melba