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.

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 195 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