Hello,
Can someone give me an example how to use this chart please ?
I would like to plot a 3 dimensionnal array but I don't know the correct syntax. Usually for other chart, we can use :
.SeriesCollection(1).XValues (x value)
.SeriesCollection(1).Values (y value)
I don't understand how to set the z ones.
I also have a problem with the line : .ChartType = xlSurface, Charttype object error, I don'y know why, something wrong with the syntax ?
Can someone give me an example how to use this chart please ?
I would like to plot a 3 dimensionnal array but I don't know the correct syntax. Usually for other chart, we can use :
.SeriesCollection(1).XValues (x value)
.SeriesCollection(1).Values (y value)
I don't understand how to set the z ones.
I also have a problem with the line : .ChartType = xlSurface, Charttype object error, I don'y know why, something wrong with the syntax ?
Code:
'Graph16 in a graph sheet on my workbook
With Graph16
Do Until .SeriesCollection.Count = 0
.SeriesCollection(1).Delete
Loop
.Activate
.SeriesCollection.NewSeries
.ChartType = xlSurface
End With
Last edited: