How To Plot 3D XYZ Data Inside Excel Links to Formulas and Programs!
This video shows how to make 3D XYZ Graphs inside of Microsoft Excel by use of Formulas and Programs to create 3D Scatter Plots, 3D Line Plots, 3D Surface Graphs, Custom Points XYZ Scatter Plots and Wire Frame Mesh Graphs.
Sources, files and products used:
Excel Unusual - https://excelunusual.com/
Gray Technical Blog Formula - https://www.graytechnical.com/blog/ho...
XYZ Mesh - https://www.graytechnical.com/xyz-mesh/
-------- Calculations --------
XYZ Data Converted to XY Data for 3D Graphing Calculations
Altitude = degrees of rotation from 1 to 360 ( Y )
Azimuth = degrees of rotation 1 to 360 ( X )
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) {– this is what you are graphing}
Yr = Sign ( XXX ) * Cos (ATan (OZ / XXX ) + BETA) * SQRT ( XXX ^2 + OZ ^2) {– this is what you are graphing}
XXX = Sign(OY)*COS(Atan(OX/OY)+ALPHA)*SQRT(OY^2+OX^2)
(equations above were modified from linked Excel Unusual URL XLS document download)
--------- ---------
Excel Unusual Example 1: https://excelunusual.com/basic-3d-2d-...
Excel Unusual Example 2: https://excelunusual.com/introduction...
--------- ---------
Intro - 00:00
3D Scatter Plots in Excel Examples - 00:40
Excel Unusual Examples - 01:00
Gray Technical Blog Formula - 02:11
XYZ Mesh - Graphing XYZ 3D Plots in Excel - 02:20
XYZ Mesh Export Sample - 3:05
How to plot multiple data series in 3D - 04:10
How to make a 3D Surface Graph MESH - 05:25
How to Plot a 3D Mesh in Excel - 07:34
Formula for curving MESH data - 08:15
XYZ Mesh convert XYZ to MESH - 09:30
XYZ Mesh convert XYZ into Complete Curve Mesh - 10:10
XYZ Mesh Curve Mesh to Excel - 10:42
Outtro - 11:16