How to switch row/column on an excel chart using C#? -

I have to display the names of the series of charts as the column names of my information. It works when I have more than 1 column, but when there is only 1 column of information, it looks like the name of the series as number 1.

I've re-presented it manually to Excel, it seems that the column name is the name of the chart, the path around it goes to the "Select Data" option, and then "switch line / Columns "option.

So my question is, how can I repeat this option using C #?

It has been detected - when setting the source of information for the chart, PlotBy parameter to xlRows . I type . Was passing in therefore it was default for xlColumns such as

  Excel.ChartObject.SetSourceData (ChartRanj, Excel.xlRowCol). XlRows);