Remember Me?

#1
June 1st 05, 06:21 PM
 dgs348 Posts: n/a
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
June 1st 05, 09:26 PM
 Andy Pope Posts: n/a

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
September 18th 07, 04:00 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 408
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post nkamp Excel Discussion (Misc queries) 0 May 26th 05 03:37 PM Paula G Charts and Charting in Excel 1 April 12th 05 11:32 PM Rosa Campos Charts and Charting in Excel 1 February 9th 05 03:55 PM gg96555 Charts and Charting in Excel 2 February 8th 05 08:36 PM Mike Charts and Charting in Excel 1 January 11th 05 01:11 PM

All times are GMT +1. The time now is 09:29 PM.