Plot a Tetrahedron in 3D using excel chart with known 3D (X,Y,Z) coordinates

Sunny Baggu

New Member
Joined
Jul 14, 2022
Messages
2
Office Version
  1. 2016
Platform
  1. 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:

1657784301451.png


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:
1657784438953.png

And the coordinates are as below in the table :
HorizontalVertical
PointsX (mm)Y (mm)Z (mm)
G118000165002000
G2610057002000
G32990057002000
G118000165002000
HorizontalVertical
Env. PosX (mm)Y (mm)Z (mm)
P11471769232000
P22090769232000
P32090789862000
P41471789862000
P11471769232000
Center of gravity coordinates
X (mm)Y (mm)Z (mm)
COG (6)17812795412307
Please suggest for any ideas or tips about the same to proceed further.
Thank you in advance for any help.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,224,820
Messages
6,181,162
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top