ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating a chart in C# (https://www.excelbanter.com/excel-programming/308141-creating-chart-c.html)

Inbar

Creating a chart in C#
 
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.


All times are GMT +1. The time now is 02:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com