Hi, just got a few question with regards to using excel to plot '3d' shapes.
I've only ever used excel to display 2d shapes but i've got some maths work which requires me to add an z coordinate.
The cube's vertices are -
i've rotated the cube 50 degrees and translated it by 0, -3.5
does anybody know how you 'emulate' the z axis as obviously excel scatter graphs work in x and y but not z.
And also, does anybody know how you can rotate by a certain point (5,4) rather than the origin. And whats the easiest way to establish the points of a line as i have to relect in a straight line (2y=x+3)
I've only ever used excel to display 2d shapes but i've got some maths work which requires me to add an z coordinate.
The cube's vertices are -
Code:
0 0 0
0 1 0
1 1 0
1 0 0
1 0 1
1 1 1
0 1 1
0 0 1i've rotated the cube 50 degrees and translated it by 0, -3.5
does anybody know how you 'emulate' the z axis as obviously excel scatter graphs work in x and y but not z.
And also, does anybody know how you can rotate by a certain point (5,4) rather than the origin. And whats the easiest way to establish the points of a line as i have to relect in a straight line (2y=x+3)