Add categorylabels in excel chart

[thuric]

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

[Melba Winshia]

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

[Administrator]

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

[Melba Winshia]

Hi Thuric,

Thanks for the update!

Kindly let me know if you have any other questions.

Regards,
Melba