long time listener, first time caller...
I'm trying to generate Excel charts using c#. I'm using Excel.Range to set a range (series of values) to plot.
However, I'd like to plot two series that are not next to each other. For example, B1:B10 and G1:G10 versus A1:A10 on the x-axis. If I try to do this using Excel.Range.get_range(), it returns all series between B and G. Is there another method to just use the series I specify?