We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Add categorylabels in excel chart

Thread ID:





58330 Mar 22,2007 07:58 AM UTC Mar 23,2007 09:40 AM UTC ASP.NET Web Forms (Classic) 3
Tags: XlsIO
Asked On March 22, 2007 07:58 AM UTC


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 :(


Melba Winshia [Syncfusion]
Replied On March 22, 2007 11:20 AM UTC

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


Here is the code snippet that I used to set CategoryLabels


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:


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.


Administrator [Syncfusion]
Replied On March 22, 2007 01:09 PM UTC

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.


Melba Winshia [Syncfusion]
Replied On March 23, 2007 09:40 AM UTC

Hi Thuric,

Thanks for the update!

Kindly let me know if you have any other questions.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon