Plotting #d grapgh in Excel

Seems like a continuation of this thread: http://www.excelforum.com/excel-gene...-in-excel.html

First, I find I must understand in mathematical terms what is going on. It looks like you have some kind of spherical coordinates (http://en.wikipedia.org/wiki/Horizon...rdinate_system http://en.wikipedia.org/wiki/Spheric...rdinate_system), and are wanting to plot these spherical coordinates in some kind of 3D (3D scatter seems most likely?) chart. Excel does not have built in support for spherical coordinates, nor does it natively support 3D scatter plots. I'm sure it can be "mocked up" in Excel, but it will require several programming steps:

1) Convert spherical coordinates to rectangular coordinates.
2) Convert X,Y data to some kind of "date" (since Excel's 3D plots do not support 3D scatter).
3) Plot these data in a 3D surface plot
4) Figure out how to label the axes to show the real values for X and Y.

Andy Pope has an example of how to create 3D scatter plots in Excel: http://andypope.info/charts/3drotate.htm

I am not familiar with other graphing packages. I know there are many that can handle 3D scatter plots. I wouldn't be surprised if there are some that can also handle spherical coordinate systems without you needing to convert to rectangular coordinates.

3d data.xlsx
Yes you are right . I wanted to plot graph as you mentioned.Since i dont know to convert SPeherical to rectangular format. I converted 3d format as per thread mentioned. Let me know hw to proceed further

http://neutrium.net/mathematics/conv...inate-systems/

I think the next step I would take would be to study Andy Pope's spreadsheet until I understood what his example was doing. It looks to me like he is using geometry to calculate XY coordinates for the points in a regular 2D scatter plot, then adding some lines for axes and the "cage" to create the 3D effect.

As this goes beyond anything I've ever had to do in Excel, I will let Andy explain any details you don't understand. If you really want to do this in Excel, I would suggest you spend some time with his example until you better understand it.