[DotNetDevelopment] Excel automation - Range - select separated columns

[Patronus]

Hi there,

I'm working on a program that dinamically generates an excel
spreadsheet, but i found a problem when I have to generate a chart
that contains data from multiple separeted columns.

The code is the following:

Dim oChart As Excel.Chart
        Dim MyCharts As Excel.ChartObjects
        Dim MyCharts1 As Excel.ChartObject
        MyCharts = xlWorkSheet.ChartObjects
        MyCharts1 = MyCharts.Add(150, 30, 400, 250)
        oChart = MyCharts1.Chart
        With oChart
            'set data range for chart
            Dim chartRange As Excel.Range
            chartRange = xlWorkSheet.Range("A3", "E50")
            .SetSourceData(chartRange)
...

This works fine for A3:C50 range, but i can't figure out a way of
handeling ranges like A3:A50 & D3:E50.

Any ideia would be appreciated

Thanks,
José