Chart Data Label Format

[OoO]

How is possible to set format of chart data label?

Thanks!

[John Bowlin Bosco K]

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]

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]

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]

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

[Johnson Monohar M]

Hi Ooo,

[Johnson Monohar M]

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 Thomson]

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

[Anibal Díaz]

Hello,

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

Regards

[Ishwarya Narayanan]

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]

Hello, thanks for your reply.

This solution don't work in Excel 97-2003.

Can you may hep me?

best regards

[Ishwarya Narayanan]

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]

thanks, work correctly!

[Ishwarya Narayanan]

Hi Anibal,

 

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

 

Regards,

Ishwarya N