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 Dec 16, 2021 10:18 pm

Hello, in Library SpireXLs, is posible have vertical lines?

In my project don´t work Gridlines in vertical.

My code C#

chart.ChartType = ExcelChartType.Line;
chart.SecondaryValueAxis.HasMajorGridLines = true;
chart.SecondaryValueAxis.HasMinorGridLines = true;
chart.SecondaryValueAxis.NumberFormat = "0,00";
chart.SecondaryValueAxis.MinValue = 0;
chart.SecondaryValueAxis.MaxValue = Math.Truncate(maxInputs) + 1;
chart.SecondaryValueAxis.MinorUnit = 2;
chart.SecondaryValueAxis.MajorUnit = 5;


Thanks
Attachments
Sin título.png
Sin título.png (19.48 KiB) Viewed 405 times

E.PTENA@LKS.ES
 
Posts: 8
Joined: Fri Nov 21, 2014 10:40 am

Fri Dec 17, 2021 1:42 am

Hello,

Thanks for your inquiry!

Please refer to the following code to set the vertical grid lines.
Code: Select all
            chart.PrimaryCategoryAxis.HasMajorGridLines = true;
            chart.PrimaryCategoryAxis.HasMinorGridLines = true;

If there are any questions, please feel free to write back.

Sincerely,
Marcia
E-iceblue support team
User avatar

Marcia.Zhou
 
Posts: 858
Joined: Wed Nov 04, 2020 2:29 am

Sat Dec 18, 2021 10:45 am

ok, thanks. You can this issue.

E.PTENA@LKS.ES
 
Posts: 8
Joined: Fri Nov 21, 2014 10:40 am

Mon Dec 20, 2021 1:12 am

Hello,

Glad to hear that the code is working.

If you encounter any issues related to our product in the future, just feel free to contact us.

Have a nice day!

Sincerely,
Marcia
E-iceblue support team
User avatar

Marcia.Zhou
 
Posts: 858
Joined: Wed Nov 04, 2020 2:29 am

Return to Spire.XLS