Our Training Programs

All contents are copyright of their authors.

C# excel: How to add 2 Y axis graphs on same chart

C# excel: How to add 2 Y axis graphs on same chart

Yigal BZ

7yAsked Oct 12, 2019, 3:26 AM2.1kC#

Can someone share a simple example of creating a chart in Excel, with 2 Y axis line graphs on same chart?

Hopefully with Interop only, yet if there is a free use add-on that simplify that, can be done as well.

For example, suppose:

The X axis data at cells "A2-A20" (A1 is the header)

The 1st Y axis data at cells "C2-C20" (C1 is the header)

The 2nd Y axis data at cells "F2-F20" (F1 is the header)

Thanks

Yigal

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Steven Peterson6y ago
ZetExcel.com is very helpful and easy to use. You should try it.
Yigal BZ7y ago
Thanks Leon, but this is not helping.
Spire is not free and limited to 5 sheets per workbook, and 200 lines per sheet
(see here: https://www.e-iceblue.com/Introduce/excel-for-net-introduce.html#.XaIEj0YzaUk )

Also, you dont show how to add the first axis and the second.
Leon D7y ago
You can use free spire.xls library (available on nuget) and the below code to add secondary y axis for chart.
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"test.xlsx");

Worksheet sheet = workbook.Worksheets[0];

Chart chart = sheet.Charts[0];

//Use the secondary y axis for chart series 1
chart.SecondaryCategoryAxis.IsMaxCross = true;
chart.Series[0].UsePrimaryAxis = false;

workbook.SaveToFile("output.xlsx", ExcelVersion.Version2013);