Hello All,
I am a newbee on this board.
I have to generate a matrix and plot data in surface plot and export it.
An element of matrix is obtained by the product of the corresponding row and column. For example 5th element in first row is 1*5=5 or 7th element in second row is 2*7
I tried to generate the matrix and given below was my best effort.
I don't have any clue abt how to get the surface plot.
Sub Surfaceplot()
Dim matrix(1 To 15, 1 To 15) As Integer
Dim i, j As Integer
For i = 1 To 15
For j = 1 To 15
matrix(i, j) = i * j
Next j
Next i
End Sub
Thanks in advance
I am a newbee on this board.
I have to generate a matrix and plot data in surface plot and export it.
An element of matrix is obtained by the product of the corresponding row and column. For example 5th element in first row is 1*5=5 or 7th element in second row is 2*7
I tried to generate the matrix and given below was my best effort.
I don't have any clue abt how to get the surface plot.
Sub Surfaceplot()
Dim matrix(1 To 15, 1 To 15) As Integer
Dim i, j As Integer
For i = 1 To 15
For j = 1 To 15
matrix(i, j) = i * j
Next j
Next i
End Sub
Thanks in advance