Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can Excel calculate area for 3-D surface charts?
I have plotted data values (z axis) based on cartesion coordinate location (x
axis and y axis) as a 3D surface chart and then changed the elevation to 90 degrees to get a topographical/isobar representation of the data. Is it possible to get the area contained within the isobar lines? If Excel can't do this is there an add-in or another product that can do this? |
#2
|
|||
|
|||
Dunno if this will help, but see Bernard Liengme's
http://www.stfx.ca/people/bliengme/E...UnderCurve.htm and http://www.stfx.ca/people/bliengme/E...olygonArea.htm -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have plotted data values (z axis) based on cartesion coordinate location (x axis and y axis) as a 3D surface chart and then changed the elevation to 90 degrees to get a topographical/isobar representation of the data. Is it possible to get the area contained within the isobar lines? If Excel can't do this is there an add-in or another product that can do this? |
#3
|
|||
|
|||
I doubt it. I think he's looking for the plan view area of each region, i.e., each
colored band between defined limits. I remember the good old days, pre-Excel. We had a fancy device called a planimeter to measure these areas. A less elaborate procedure consisted of cutting out the areas and weighing them, dividing by the total weight, and multiplying by the total area. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Tushar Mehta wrote: Dunno if this will help, but see Bernard Liengme's http://www.stfx.ca/people/bliengme/E...UnderCurve.htm and http://www.stfx.ca/people/bliengme/E...olygonArea.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
how do i calculate the area under a curve? | Charts and Charting in Excel | |||
finding the area under the curve in a graph in excel | Excel Discussion (Misc queries) | |||
Excel Charts | Charts and Charting in Excel | |||
Why will my Excel charts not print in color? | Charts and Charting in Excel |