We found a match
Your institution may have access to this item. Find your institution then sign in to continue.
- Title
An Excel Macro for Generating Trilinear Plots.
- Authors
Shikaze, Steven G.; Crowe, Allan S.
- Abstract
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.
- Subjects
ELECTRONIC spreadsheets; TRILINEAR forms; MACRO instructions (Electronic computers); VISUAL programming languages (Computer science); MICROSOFT Corp.; DATA entry
- Publication
Ground Water, 2007, Vol 45, Issue 1, p106
- ISSN
0017-467X
- Publication type
Article
- DOI
10.1111/j.1745-6584.2006.00264.x