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
|
|||
|
|||
Can I plot XYZ points in excel?
I would like to plot 3D (X,Y,Z) points in excel, similar to and XY Scatter
but with a third axis. The surface graph type does not do what I want because it can't plot scaled numerical values on 2 of 3 axis. Does anyone know how I can do this? Thank you |
#2
|
|||
|
|||
Hi,
This chart type is not available built-in. I have some information on mimicking a 3d plot using xy-scatter and formula. http://www.andypope.info/charts/3drotate.htm It currently plot points but can be adapted to plot a mesh. Cheers Andy dgs348 wrote: I would like to plot 3D (X,Y,Z) points in excel, similar to and XY Scatter but with a third axis. The surface graph type does not do what I want because it can't plot scaled numerical values on 2 of 3 axis. Does anyone know how I can do this? Thank you -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Can I plot XYZ points in excel?
Hi, because my problem is very similar/related to this I dint open a new
thread but I am continuing here. As explained by Andy Pope I did a 3D excel chart and everything is OK. I just want to go a step further and find a way to automatically adjust the minimum and maximum axis/cage data values to those which will be actually plotted. For example: I have data plotted those x,y,z values can be 500 or 5000. And since my cage/axis data is predefined to a fixed value (to accommodate bigger data), small data doesn’t look good in plot. Is any way to do this? TIA TIm "Andy Pope" wrote: Hi, This chart type is not available built-in. I have some information on mimicking a 3d plot using xy-scatter and formula. http://www.andypope.info/charts/3drotate.htm It currently plot points but can be adapted to plot a mesh. Cheers Andy dgs348 wrote: I would like to plot 3D (X,Y,Z) points in excel, similar to and XY Scatter but with a third axis. The surface graph type does not do what I want because it can't plot scaled numerical values on 2 of 3 axis. Does anyone know how I can do this? Thank you -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I plot Excel data on a floorplan? | tod1west | General Discussion | 1 | January 28th, 2005 02:11 AM |
WHY | General Discussion | 9 | December 16th, 2004 12:49 AM | |
How many data points can you have in an Excel for a Scatter Chart. | gregran | Charts and Charting | 3 | December 10th, 2004 07:31 PM |
Can I plot a semi-log graph in Excel 2000? | rhon | General Discussion | 1 | October 19th, 2004 02:05 AM |
outputting memo fields to excel | John Baker | Running & Setting Up Queries | 7 | August 12th, 2004 01:23 PM |