to generate surface plot from data

ushank

New Member
Joined
Sep 27, 2006
Messages
3
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
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,113,918
Messages
5,545,025
Members
410,647
Latest member
bernardazar
Top