Premium
An Excel Macro for Generating Trilinear Plots
Author(s) -
Shikaze Steven G.,
Crowe Allan S.
Publication year - 2006
Publication title -
groundwater
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.84
H-Index - 94
eISSN - 1745-6584
pISSN - 0017-467X
DOI - 10.1111/j.1745-6584.2006.00264.x
Subject(s) - worksheet , macro , visual basic for applications , microsoft excel , computer science , ms excel , computer graphics (images) , plot (graphics) , set (abstract data type) , graphics , visual basic , simple (philosophy) , scatter plot , engineering drawing , programming language , software , software engineering , mathematics , operating system , statistics , engineering , philosophy , mathematics education , epistemology , machine learning
This computer note describes a method for creating trilinear plots in Microsoft Excel. Macros have been created in MS Excel’s internal language: Visual Basic for Applications (VBA). A simple form has been set up to allow the user to input data from an Excel worksheet. The VBA macro is used to convert the triangular data (which consist of three columns of percentage data) into X‐Y data. The macro then generates the axes, labels, and grid for the trilinear plot. The X‐Y data are plotted as scatter data in Excel. By providing this macro in Excel, users can create trilinear plots in a quick, inexpensive manner.