B
barbara_dave
Hi, all,
I need to make a chart with a spreadsheet data in VB.net,
I got problem of its syntax.
How to make the following code work in vb.net?
Dim ochart As Object
Dim c As Object
With ChartSpace1
.Clear()
.Refresh()
.DataSource = spreadSheet1.object
ochart = .Charts.Add
End With
oChart.SeriesCollection.Add()
c = ChartSpace1.Constants
With ChartSpace1.Charts(0)
With .SeriesCollection(0)
.SetData(c.chDimSeriesNames, 0, "A4")
.SetData(c.chDimValues, 0, "F" & 4
& ":I"& 4)
......
I got run-time error like invalid cast, please give me
some instructions!
Thanks!
I need to make a chart with a spreadsheet data in VB.net,
I got problem of its syntax.
How to make the following code work in vb.net?
Dim ochart As Object
Dim c As Object
With ChartSpace1
.Clear()
.Refresh()
.DataSource = spreadSheet1.object
ochart = .Charts.Add
End With
oChart.SeriesCollection.Add()
c = ChartSpace1.Constants
With ChartSpace1.Charts(0)
With .SeriesCollection(0)
.SetData(c.chDimSeriesNames, 0, "A4")
.SetData(c.chDimValues, 0, "F" & 4
& ":I"& 4)
......
I got run-time error like invalid cast, please give me
some instructions!
Thanks!