HomeНаука и техникаRelated VideosMore From: Gray Technical

How to Fix Missing Tick-Marks in Excel Surface Plots XYZ Mesh

4 ratings | 561 views
This video explains in detail how to fix missing data points and tick marks inside Microsoft Excel’s Surface Plots. In this video we use two methods. One uses custom made formulas to created fillers within the missing data points and the other uses a third party application, XYZ Mesh. XYZ Mesh is a software specifically created to convert XYZ data into a MESH format specifically used by Microsoft Excel. XYZ Mesh also comes with ‘theoretical points’ which will automatically fill in any missing data points that may not plot inside Microsoft Excel. XYZ Mesh Webpage: http://www.graytechnical.com/software/xyz_mesh/ ------------------------- ------------------------- The formulas used in the video are listed below: ------------------------- One row: A = First Value B = Empty Gap C = Second Value B=(A+C)/2 ------------------------- Multiple Rows: AX = First Value With Row Number B = Empty Gap C = Empty Gap Row Count DX = Second Value With Row Number B=((D$X-A$X)/(C + 1))+AX -------------------------
Html code for embedding videos on your blog
Text Comments (0)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.