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.
Unfortunately, activation email could not send to your email. Please try again.

Chart Data Label Format

Thread ID:

Created:

Updated:

Platform:

Replies:

99479 May 23,2011 04:31 PM Apr 27,2016 01:45 AM ASP.NET Web Forms (Classic) 13
loading
Tags: XlsIO
OoO
Asked On May 23, 2011 04:31 PM

How is possible to set format of chart data label?

Thanks!


John Bowlin Bosco K [Syncfusion]
Replied On May 24, 2011 04:35 AM

Hi OoO,

Thank you very much for your interest in Syncfusion Products.

Using Essential XlsIO, the data labels for charts can be set with the help of IchartDataLabels interface. To format data labels, we have created a sample in which data labels are set for different series and the sample has been attached below. Could you please try the sample from the link and let us know if this helps you?

Sample Link:
http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=ChartDataLabelSample807008918.zip

Please let us know if you need any further assistance.

Regards,
Pauline Bosco


OoO
Replied On May 24, 2011 07:57 AM

Hi!

Thanks for your assistance, but this not what I need. I would like to set number format for data labels, like in attached Excel file.



XlsIOSample_64161166.zip

John Bowlin Bosco K [Syncfusion]
Replied On May 25, 2011 01:43 AM

Hi OoO,

Thank you very much for your update.

Currently, Essential XlsIO does not provide support to format number values in data labels. Regarding this functionality, we have logged a feature report and it has been forwarded to our development team for further process. Also, we do not have any immediate plans to implement this feature. So, we will get back to you once the requested feature has been implemented in one of our forthcoming releases.

Please let us know if you require any further clarifications.

Regards,
Pauline Bosco


Min Lai
Replied On June 7, 2012 05:04 PM

Does XlsIO provide to format number values in data label in the - 10.2.0.56 version?


Johnson Monohar M [Syncfusion]
Replied On June 8, 2012 12:43 AM

Hi Ooo,

Johnson Monohar M [Syncfusion]
Replied On June 8, 2012 12:48 AM

Hi OoO,

We are sorry for the inconvenience.

XlsIO does not support number formatting of datalabels on 10.2.0.56v. As reported earlier, it has been logged as a feature report. We will get back to you once it is implemented.

Before that, we request you to open a DirectTrac incident for the same to have a better follow-up. Kindly let us know if you need any clarification.

Thanks,
Johnson

Russell
Replied On June 27, 2014 05:19 AM

Bumping this - does XlsIO support number formatting of data labels yet?

Anibal Díaz
Replied On February 9, 2016 10:51 AM

Hello,

this functionality "format number values in data labels" is available on version 13.4.0.53?

Regards

Ishwarya Narayanan [Syncfusion]
Replied On February 10, 2016 04:02 AM

Hi Anibal,

 

Yes, format number values in data labels is available in our latest version 13.4. We have prepared a simple sample as per your scenario in the following link. Kindly try this sample and let us know if it helps.

Also you could refer the following code sample to set the number format for the data labels using XlsIO.

 

Sample Link:   http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample-1228247968

 

Code Sample:

 

(chart.Series[0].DataPoints.DefaultDataPoint.DataLabels as ChartDataLabelsImpl).IsValue = true;

(chart.Series[0].DataPoints.DefaultDataPoint.DataLabels as ChartDataLabelsImpl).NumberFormat = "0.0%";

 

Regards,

Ishwarya N


Anibal Díaz
Replied On April 25, 2016 05:23 AM


Hello, thanks for your reply.

This solution don't work in Excel 97-2003.
Can you may hep me?

best regards

Ishwarya Narayanan [Syncfusion]
Replied On April 26, 2016 03:21 AM

Hi Anibal,

 

Yes, you must enable IsCustomNumberFormat property to set the number format for data labels in Excel 97- 2003. The following code example illustrates this behavior.

 

Code Example:

(chart.Series[0].DataPoints.DefaultDataPoint.DataLabels as ChartDataLabelsImpl).IsValue = true;

(chart.Series[0].DataPoints.DefaultDataPoint.DataLabels as ChartDataLabelsImpl).NumberFormat = "0.0%";

 

(chart.Series[0].DataPoints.DefaultDataPoint.DataLabels as ChartDataLabelsImpl).TextArea.ChartAI.IsCustomNumberFormat = true;

 

We have shared the sample for your reference which can be downloaded from following link.

 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample-1031951893

 

Please try this sample and let us know if it helps.

 

Regards,

Ishwarya N


Anibal Díaz
Replied On April 26, 2016 07:06 AM

thanks, work correctly!

Ishwarya Narayanan [Syncfusion]
Replied On April 27, 2016 01:45 AM

Hi Anibal,

 

Thank you for your update. Please let us know if you need further assistance on this.

 

Regards,

Ishwarya N


CONFIRMATION

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.

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.

;