Look for the download link on that page (usually an arrow pointing down at the top of the page- move your mouse around to reveal) to save it. When you follow that link, google drive will show you the contents of the spreadsheet, which are far more disorganized than the spreadsheet itself. You can get the spreadsheet to follow along here. The last thing is to make sure they are drawn from back to front. Along the way we will want to do other things, like rotate and move the points. The main step is projecting the 3d points into 2d space. So, when a series of XYZ points is entered into Excel, they can be projected into a simple XY series and plotted in a normal 2d scatter graph. All a 3d image is is simply a projection of the 3d points onto a 2d plane. It suddenly appeared to me that because I have done a considerable amount of 3-d graphics programming in designing my research methods, that the same techniques should apply. With a tat of diligence, a bit of focus, and some patience, you should be on your way after going through this post. But its not as hard as you might think (its not hard at all). You have to engage in a little 3-d programming. There is no magic bullet, no special menu trick. I don’t know how useful these latter products are as I haven’t spent the money on them. There are also commercial add-ins you can buy. There are add-ins you can use, that are of limited help in most cases. Ever wanted to make a 3-d Scatterplot and find that Excel just won’t do it? I have.
0 Comments
Leave a Reply. |