Sunny Baggu
New Member
- Joined
- Jul 14, 2022
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hii, Greetings!
I want to Plot a Tetrahedron in 3D using excel chart with known 3D (X,Y,Z) coordinates.
Lets say my known coordinates are:
Now if you see carefully, the Z-coordinates for center of gravity is 12307 mm which is different from points G1,G2,G3,1,2,3 and 4.
The requirement for me is to plot COG in 3D view and connect it CoG (TIP) to all the other points at 2000 mm level i.e., with points G1,G2,G3,1,2,3 and 4.
In simple words, along with the plan and in 3 D view all the coordinates should be connected, i.e, CoG(6) with G1, CoG(6) with G2, CoG(6) with G3, CoG(6) with point 1, CoG(6) with point 2, CoG(6) with 3, and CoG(6) with point 4.
In 3D view , its looks like below:
And the coordinates are as below in the table :
Please suggest for any ideas or tips about the same to proceed further.
Thank you in advance for any help.
I want to Plot a Tetrahedron in 3D using excel chart with known 3D (X,Y,Z) coordinates.
Lets say my known coordinates are:
Now if you see carefully, the Z-coordinates for center of gravity is 12307 mm which is different from points G1,G2,G3,1,2,3 and 4.
The requirement for me is to plot COG in 3D view and connect it CoG (TIP) to all the other points at 2000 mm level i.e., with points G1,G2,G3,1,2,3 and 4.
In simple words, along with the plan and in 3 D view all the coordinates should be connected, i.e, CoG(6) with G1, CoG(6) with G2, CoG(6) with G3, CoG(6) with point 1, CoG(6) with point 2, CoG(6) with 3, and CoG(6) with point 4.
In 3D view , its looks like below:
And the coordinates are as below in the table :
Horizontal | Vertical | ||
Points | X (mm) | Y (mm) | Z (mm) |
G1 | 18000 | 16500 | 2000 |
G2 | 6100 | 5700 | 2000 |
G3 | 29900 | 5700 | 2000 |
G1 | 18000 | 16500 | 2000 |
Horizontal | Vertical | ||
Env. Pos | X (mm) | Y (mm) | Z (mm) |
P1 | 14717 | 6923 | 2000 |
P2 | 20907 | 6923 | 2000 |
P3 | 20907 | 8986 | 2000 |
P4 | 14717 | 8986 | 2000 |
P1 | 14717 | 6923 | 2000 |
Center of gravity coordinates | |||
X (mm) | Y (mm) | Z (mm) | |
COG (6) | 17812 | 7954 | 12307 |
Thank you in advance for any help.