This is similar to Fred's. Except some different plots. 3D plots as Fred made seem to be restricted to having the X and Y simply be counters (1,2,3, etc) The contour plot isn't what you asked for, but may be the most visual.
Always state which version (and subversion) of Mathcad you are using! Prime or real Mathcad. If Prime then its very important to state the exact version, as they are incompatible (at least they are not compatible in a useful way).
Also it would always help if you attach your worksheet.
I guess you know how to get your excel data in Mathcad and how to split row- and column-header and data.
You could plot your data right away but have to take into account a lot of drawbacks.
You lose the information about x (time) and Y. Those values are substituted by the sequence 0,1,2,3,4,5.
Because of this you see a wrong (logarithmic) scale in y direction!
Depending on what you are looking for there a different approaches.
You may want to interpolate your data, turning the table into a function.
Simplest form is linear interpolation:
More sophistic is using splines for interpolation
Mathcad offer three different flavors for cubic splines - cspline, pspline, lspline.
As you can see, I used cspline. If you change that for lspline the result should be the very same as if using the built-in Bicubic2D.
There is a slight difference between the two as you can see in the attached sheet.
The data used by Mathcad to show a 3d surface is a little bit complicated and consists of three nested matrices. Here is a way to build that structure from row-, column-header and data table and then plot the pure data:
Attached file in format Prime 3.0.
P.S.: I am not sure what Fred intended as in fact he simply put two columns in front of the data table (accidentally overwriting the first data column) which means we plot wrong data, I guess.
dferry in his first reply (apart from using differently scaled data) simply created a three column matrix - a long list of points.
That way he is losing completely the mesh information - which point is neighbor of which.
I asked here in the past quite a few time if anybody would know which kind of function Mathcad would try to fit over just a bunch of data points if asked to do a surface plot (I think Prime refuses to do so, nevertheless happily provides a contour plot?). So far nobody could answer that question. What we know is that its not an interpolation but rather an approximation. The surface Mathcad creates usually does not include the datapoints exactly but rather follows them as good as it can (whatever that may mean).
Therefore I guess its not a good idea to abandon the mesh-information. Even though dferry did not create a surface plot in his first answer he showed a contour plot, which also would force Prime to create some kind of surface.
