J
jimbo_jones
Is it possible to make a 3D plot in Excel 2003? If so could I get the
steps, thanks
steps, thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
HS Hartkamp
Everything is possible, it's just a matter of how much time and effort you
are willing to spend.
Some 15 years ago, I wrote a program in Pascal, that plotted a projection of
a series of lines and points in (x,y,z) coordinates onto a (2D) computer
screen. Another input parameter was the (x,y,z) coordinates of the point of
view. This took me 5 weeks trying high school trigonometry formulas, because
I thought matrix-calculations were too complex. I did not succeed.
A year later, someone told me to use matrices, and I did the whole thing in
a single afternoon. I think if you know how, it should be relatively simple
to do it in excel.
Take your matrix (3 x #Points) with x-y-z coordinates, and transform this by
multiplying by a 2 x 3-matrix to get a new (2 x #Points) matrix with the
2D-projection. Then use a x-y-scattergraph to display the results.
Unfortunalely, I forgot the details, but I should still have the code, and
if you like, I can send it to you to help you on the way (send me an
e-mail). I'm sure that with today's computing possibilities it should be
much easier than back in those days.
Bas Hartkamp.
PS: Two years later the program got us planning permission and a $ 10.000
grant to build a new shed on a campsite, so the time was well spend.
"jimbo_jones" <[email protected]>
schreef in bericht
news:[email protected]...
are willing to spend.
Some 15 years ago, I wrote a program in Pascal, that plotted a projection of
a series of lines and points in (x,y,z) coordinates onto a (2D) computer
screen. Another input parameter was the (x,y,z) coordinates of the point of
view. This took me 5 weeks trying high school trigonometry formulas, because
I thought matrix-calculations were too complex. I did not succeed.
A year later, someone told me to use matrices, and I did the whole thing in
a single afternoon. I think if you know how, it should be relatively simple
to do it in excel.
Take your matrix (3 x #Points) with x-y-z coordinates, and transform this by
multiplying by a 2 x 3-matrix to get a new (2 x #Points) matrix with the
2D-projection. Then use a x-y-scattergraph to display the results.
Unfortunalely, I forgot the details, but I should still have the code, and
if you like, I can send it to you to help you on the way (send me an
e-mail). I'm sure that with today's computing possibilities it should be
much easier than back in those days.
Bas Hartkamp.
PS: Two years later the program got us planning permission and a $ 10.000
grant to build a new shed on a campsite, so the time was well spend.
"jimbo_jones" <[email protected]>
schreef in bericht
news:[email protected]...
H
HS Hartkamp
Actually quite easy. Send me an e-mail if you want an example.
Bas
Bas