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.

Thu Nov 10, 2016 2:49 pm

Hi

I want to make an axis in percent.
I do that but it's don't change axis numbre format

Code: Select all
var chart = sheet.Charts.Add();
var series = chart.Series.Add();
series.EnteredDirectlyValues = new object[] {1, 2};

chart.PrimaryValueAxis.NumberFormat = "0%";


I don't know if i make something wrong or if it's a bug.

Thanks.

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Fri Nov 11, 2016 4:02 am

Hi VincentB,

Thanks for your inquiry. Please add the following code.
Code: Select all
chart.PrimaryValueAxis.IsSourceLinked = false;

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1187
Joined: Tue Sep 27, 2016 1:06 am

Mon Nov 14, 2016 9:36 am

It' works !!

Thanks.

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Tue Nov 15, 2016 3:47 am

Dear VincentB,

Thanks for your feedback. Please feel free to contact us if you have any questions.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1187
Joined: Tue Sep 27, 2016 1:06 am

Return to Spire.XLS