If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I chart contours in Excel 2007?
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 |
#2
|
|||
|
|||
How do I chart contours in Excel 2007?
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 |
#3
|
|||
|
|||
How do I chart contours in Excel 2007?
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/con...in-excel-2007/ Surface and Contour Charts in Microsoft Excel http://pubs.logicalexpressions.com/P...cle.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 |
Thread Tools | |
Display Modes | |
|
|