Contours

[corus]

Is there any method or add-in avaliable that can do contour plots of discrete geophysical data. The surface plot available in excel isn't much good as far as I can see unless you assume your 2D geometry can be transposed into neat integer rows and columns that hold the value of the Z variable. I've seen other software that can do contours of data but it would be preferable if something was available that could be run from within excel.

corus

 

[joerd]

It is not really supported, I don't think. Maybe this article:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=447

has some useful tips.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[dogtop]

corus,

If you are adventurous and not afraid to leave MS Excel, there is R software that has several packages (libraries) that deal with geophysical data. The URLs are:

http://www.r-project.org/

http://cran.r-project.org/doc/packages/PBSmapping.pdf

You could use their search facility to get more details.

HTH

dogtop

 

[BigInch]

If you can handle a VB6 program, I could send the source code to you.

BigInch-born in the trenches.

http://virtualpipeline.spaces.msn.com

 

[corus]

Many thanks BigInch et al. I've found a method now of fitting a grid over the data and applying an inverse distance rule to fit to the data so that the grid of numbers can be contoured by the surface plot using VB6, which I think I can manage.

corus