Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Jan 31, 2018 9:01 pm

The version of Spire.XLS that we have (Version: 7.11.13.7040 / Runtime: v4.0.30319) does not have the capability to have a data label value other than the plot point value on a line chart. If it is capable of that, we haven't been able to figure it out. Does the newer version of Spire.XLS support this excel feature?

For instance, a plot point could have a value of, say, "30". The point on the chart shows correctly, but the data label will also show a value of "30". In excel you can have a different Data Label value display even if the plot point is "30". So we'd like to do something along the lines of:

plot point = 30
data label = "today"

We are able to do this in excel, but as soon as Spire.XLS reads the excel file, it converts the data label to also be "30".

Thanks!

snw1969
 
Posts: 1
Joined: Mon Aug 11, 2014 9:11 pm

Thu Feb 01, 2018 3:52 am

Dear snw1969,

Thanks for your inquiry.
Spire.XLS supports to do that, and there are two situations.
1. Change the datalabels of datapoint directly, please refer to following code.
Code: Select all
ChartSerie.DataPoints[i].DataLabels.TextArea.Text = "today";

2. Value from cells.
https://www.e-iceblue.com/Tutorials/Spi ... -in-C.html
If you still have the issue, please provide us with your input/expected Excel document for further investigation.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Mon Feb 05, 2018 8:40 am

Dear snw1969,

Greetings from E-iceblue.
Has your issue been resolved ? Could you please give us some feedback at your convenience ?

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS