Prev: Secondary axes issues
Next: I cannot set the maximum date for the axis of a line chart
From: tpmbrian on 3 Mar 2010 10:29
I have some geophysical data I want to chart. How can I generate contours, or
with the surface chart, how can I change the values for the coloured bands?
Thank you
From: trip_to_tokyo on 3 Mar 2010 13:19
EXCEL 2007

Try a Surface Chart.

To set one up:-

Hit the F1 Help Facility Key

In the Browse Excel Help section click on Charts

Next click on Chart types

Next click on Present your data in a surface chart

There are detailed instructions in here as to how to set one up.

If my comments have helped please hit Yes.











"tpmbrian" wrote:

> I have some geophysical data I want to chart. How can I generate contours, or
> with the surface chart, how can I change the values for the coloured bands?
> Thank you
From: Jon Peltier on 4 Mar 2010 10:42
Don't get your hopes up, Excel's contour/surface charts are not very
sophisticated. The long and lat are categorical, not numeric, and the
algorithms that generate contours is rudimentary.

I've written about these charts in details:

Contour and Surface Charts in Excel 2007
http://peltiertech.com/WordPress/contour-and-surface-charts-in-excel-2007/

Surface and Contour Charts in Microsoft Excel
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=447

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/3/2010 10:29 AM, tpmbrian wrote:
> I have some geophysical data I want to chart. How can I generate contours, or
> with the surface chart, how can I change the values for the coloured bands?
> Thank you
 | 
Pages: 1
Prev: Secondary axes issues
Next: I cannot set the maximum date for the axis of a line chart