CE Interop excel: How to create 2 Y axis graphs on same chart?

[YigalB]

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

Hopefully with Interop only.

I can easily open the excel, read/write data. The problem is with creating a chart.

I would appreciate a simple example, I tried several example from web, most require non-free add-on. The free ones have limitations, while my excel has 20k+ lines.

I use Visual Studio 2017, version 15.9.16


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

Continue reading...