An Excel Macro for Generating Trilinear Plots Journal Articles

abstract

• AbstractThis 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.

authors

• Shikaze, Steven G
• Crowe, Allan

status

• published 

publication date

• January 2007

has subject area

• 0406 Physical Geography and Environmental Geoscience (FoR)
• 0799 Other Agricultural and Veterinary Sciences (FoR)
• Aerobiosis (MeSH)
• Anaerobiosis (MeSH)
• Environmental Engineering (Science Metrix)
• Pesticides (MeSH)
• Software (MeSH)
• User-Computer Interface (MeSH)
• Water Pollutants (MeSH)

published in

• Ground Water  Journal

keywords

• Aerobiosis
• Anaerobiosis
• Pesticides
• Software
• User-Computer Interface
• Water Pollutants

Digital Object Identifier (DOI)

• 10.1111/j.1745-6584.2006.00264.x

PubMed ID

• 17257347

start page

• 106

end page

• 109

volume

• 45

issue

• 1