Hello,

I read a lot of topics concerning the 3d chart but I did not find a good solution for my simple problem.

I read that I should use the surface one since it is the only viable 3d chart for Excel.

I would like to chart in 3D my 3 one dimensionnal arrays data (or one 3 dimensionnal array) : x, y ,z.

Could someone help me to write it on VBA ?


dim arr_x() as double, arr_y() as double, arr_z() as double
dim i as integer
redim arr_x(1 to 10), arr_y(1 t o10), arr_z(1 to 10)

for i = 1 to 10
arr_x(i) = i*1
arr_y(i) = i*10
arr_z(i) = i*100

'Graph2 is one graph on my workbook
    With Graph2

        .Activate
        .name = "name"
        .ChartType = xlSurface
        .SeriesCollection.NewSeries
        .SeriesCollection(1).XValues = Array(arr_x)
        .SeriesCollection(1).Values = Array(arr_y)
        .SeriesCollection(1).Format.Line.Visible = True
     
    End With
next i