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
-
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
-
Jane.Bai
-
- Posts: 1156
- Joined: Tue Nov 29, 2016 1:47 am