3D Plot

[jimbo_jones]

Is it possible to make a 3D plot in Excel 2003, I mean X,Y,Z? If so could I get the steps, thanks

[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" <jimbo_jones.1yygim_1132758601.1263@excelforum-nospam.com>
schreef in bericht
news:jimbo_jones.1yygim_1132758601.1263@excelforum-nospam.com...
>
> Is it possible to make a 3D plot in Excel 2003? If so could I get the
> steps, thanks
>
>
> --
> jimbo_jones
> ------------------------------------------------------------------------
> jimbo_jones's Profile:
> http://www.excelforum.com/member.php...o&userid=27244
> View this thread: http://www.excelforum.com/showthread...hreadid=487642
>

[HS Hartkamp]

Actually quite easy. Send me an e-mail if you want an example.

Bas

"HS Hartkamp" <hartkamp.NOSPAAM@wanadoo.nl> schreef in bericht
news:43878d25$0$99438$dbd4f001@news.wanadoo.nl...
>
> 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" <jimbo_jones.1yygim_1132758601.1263@excelforum-nospam.com>
> schreef in bericht
> news:jimbo_jones.1yygim_1132758601.1263@excelforum-nospam.com...
>>
>> Is it possible to make a 3D plot in Excel 2003? If so could I get the
>> steps, thanks
>>
>>
>> --
>> jimbo_jones
>> ------------------------------------------------------------------------
>> jimbo_jones's Profile:
>> http://www.excelforum.com/member.php...o&userid=27244
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=487642
>>
>
>