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.

not able add % on DataLabels in Bar chart.

Thread ID:

Created:

Updated:

Platform:

Replies:

127920 Dec 19,2016 04:03 AM Feb 13,2017 03:55 AM ASP.NET Web Forms 4
loading
Tags: Presentation
geetanjali
Asked On December 19, 2016 04:03 AM

Dear Team,

I am using syncfusion library for ppt export in my web form application. I want to add % symbol along with data labels or you can say my data is showing some percent values on chart and i want to display % sign with datalabel values. Please let me know how i can do that. Kindly check my attached code if i am doing something wrong.

Attachment: WebAppExcelUpload_e72a3029.zip

Devisri Jothi [Syncfusion]
Replied On December 20, 2016 06:52 AM

Hi Geetanjali, 
Thank you for contacting Syncfusion support. 
We checked the provided web sample and couldn’t find any code snippet related to Presentation library.  However, we have created a sample to show how to set the data label of a chart in percentage format using Presentation library. Please review the sample and let us know if it satisfies your requirement. 
In MS PowerPoint, the data label option – Percentage is not available for bar chart types. Please refer the below screenshot, 
 
Similarly, IsPercentage and IsValue properties does the equivalent functionality for pie chart and bar chart respectively using Presentation library. You may also refer the following online UG documentation to explore more about working with charts, 
Please let us know if you need any clarification on this. 
Regards, 
Devisri 


geetanjali
Replied On December 20, 2016 08:06 AM

Hi...

Actually i tried doing changing the excel cell format in ChartData. If i change the cell format to percentage, then percentage sign come over data labels. But i cannot do this using library. I didn't find any code snippet to do so. when i set chartData , _sheet instances are private only. We cannot modify their cell type.

Thanks.

Devisri Jothi [Syncfusion]
Replied On December 21, 2016 07:48 AM

Hi Geetanjali, 
While creating a sample with bar chart to meet your requirement, we found an issue on setting the data label with percentage symbol. We have logged a defect report for the same in our database. This fix is estimated to be available in our Volume 1, 2017 main release which is expected to be available in the month of February, 2017. 
Regards, 
Devisri 


Devisri Jothi [Syncfusion]
Replied On February 13, 2017 03:55 AM

Hi Geetanjali, 

The issue - Enable data label of the bar chart with percentage symbol has been fixed and is included in our Volume 1, 2017 release. Below are the public API details to display the chart data label as percentage value. 

Interface 
Type 
API Name 
Summary 
IOfficeChartDataLabels 
string 
NumberFormat 
Gets or sets the format string for data label object. 

You may download the sample from the following link that explains how to set the number format for the data labels of a chart, 


We are glad to announce that our Essential Studio Volume 1, 2017 is rolled out and is available for download under the following link. 

                                    
We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 

Regards, 
Devisri 


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.

;