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 Oct 26, 2021 4:44 pm

Good day,

Can you kindly advise me on how I can create a grouped y-axis on an excel chart via C#.
Example has been attached . So basically I want my y -axis to be grouped by two columns in which the first column is the main category and the 2nd column is the sub -category.
I am able to do it manually in excel but not programmatically via C#.

I have uploaded a pic of the chart I created manually in excel.

The attachment groupedYAxis.PNG is no longer available
Attachments
groupedYAxis.PNG
groupedYAxis.PNG (14.74 KiB) Viewed 1764 times

predeshni
 
Posts: 4
Joined: Tue Oct 26, 2021 4:29 pm

Wed Oct 27, 2021 6:15 am

Hello,

Thank you for contacting.
Please refer to this tutorial(Create Multi-Level Category Chart in Excel) to achieve your demand. If there is still any issue, to help have a further investigation, please share us with your full testing code as well as your input file(if any). You could attach it here or send it to us via email (support@e-iceblue.com).

Sincerely,
Lisa
E-iceblue support team
User avatar

Lisa.Li
 
Posts: 1261
Joined: Wed Apr 25, 2018 3:20 am

Wed Oct 27, 2021 7:02 am

Thank you Lisa , I will try this out and let you know if it works.

predeshni
 
Posts: 4
Joined: Tue Oct 26, 2021 4:29 pm

Wed Oct 27, 2021 7:26 am

Hello,

Thanks for your quick response.
If you encounter any issues when testing, please feel free to contact us.

Sincerely,
Lisa
E-iceblue support team
User avatar

Lisa.Li
 
Posts: 1261
Joined: Wed Apr 25, 2018 3:20 am

Return to Spire.XLS