Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application and Java (J2SE and J2EE) application.

Tue Dec 11, 2018 6:45 am

Hello,

I want to rotate title of Y Axis 90 degrees (Horizontal).

Current situation in attachment.

Thanks!
Attachments
ClosedXMLResultLineChart.rar
(7.47 KiB) Downloaded 64 times

rickyjessy
 
Posts: 16
Joined: Fri Nov 23, 2018 8:20 am

Tue Dec 11, 2018 8:39 am

Hi,

Thank you for your inquiry.
Please refer to the following code to reach your goal.
Code: Select all
Workbook workbook = new Workbook();
workbook.LoadFromFile(path);
Chart chart = workbook.Worksheets[0].Charts[0] as Chart;
//set the text direction
chart.PrimaryValueAxis.TitleArea.TextRotationAngle =0;
workbook.SaveToFile(@"output.xlsx");


Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Tue Dec 11, 2018 9:56 am

Hi,

Thanks you for your response.

It's really help me!

I am pretty grateful.

Thanks!

rickyjessy
 
Posts: 16
Joined: Fri Nov 23, 2018 8:20 am

Tue Dec 11, 2018 10:00 am

Hi,

Thank you for your valuable feedback.
Just feel free to contact us if you need any assistance in the future. :)

Sincerely,
Jane
E-iceblue support etam
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Return to Spire.XLS