How to graph X Y Z data in 3D inside Microsoft Excel with XYZ Rotations
In this video I would like talk about how you can graph XYZ data in 3D using Microsoft Excel, specifically line, spline or scatter charts. This video will be covering one third party application that makes this task very simple and how you can accomplish this yourself using user defined formulas.
Application: Cel Tools
Application URL: http://www.graytechnical.com/celtools/
Gray Technical, LLC
XYZ Mesh - https://www.graytechnical.com/xyz-mesh/
------------------------------
Excel Unusual: http://www.excelunusual.com/
------------------------------
User Defined Formulas:
Altitude = degrees of rotation from 1 to 360
Azimuth = degrees of rotation 1 to 360
ALPHA = (3.1415926535/180)*Azimuth
BETA = (3.1415926535/180)*Altitude
OX = (Original Z Values)
OY = (Original Y Values)
OZ = (Original Z Values)
Xr = Sign (OY) * Sin (ATan ( OX / OY ) + ALPHA) * SQRT( OY^2 + OX^2)
Yr = Sign ( XXX ) * Cos (ATan (OZ / XXX ) + BETA) * SQRT ( XXX ^2 + OZ ^2)
XXX = Sign(OY)*COS(Atan(OX/OY)+ALPHA)*SQRT(OY^2+OX^2)
------------------------------
Final formulas used in video:
Xr: = SIGN(B2) * SIN(ATAN( A2 / B2 ) + $R$7) * SQRT( B2^2 + A2^2)
Yr: = SIGN((SIGN(B2)*COS(ATAN(A2/B2)+$R$7)*SQRT(B2^2+A2^2))) * COS(ATAN(C2 / (SIGN(B2)*COS(ATAN(A2/B2)+$R$7)*SQRT(B2^2+A2^2)))+$R$9)*SQRT((SIGN(B2)*COS(ATAN(A2/B2)+$R$7)*SQRT(B2^2+A2^2))^2 + C2 ^2)