I'm creating a chart and trying to set the source data using this call:

chart.SetSourceData((EXCEL.Range)(((EXCEL.Workshee t)excel.Worksheets["Sheet1"]).Columns["T:Z", missing]), 2);

The chart should use columns T-Z as its data source.
I'm getting an exception on this code saying type mismatch. the indexer for
Columns will only accept an integer. How do then I create the range object
for all these columns?

Thanks,

Inbar.