title: An Excel macro for generating trilinear plots.
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.
authors.affiliation: EarthFX Incorporated, 3363 Yonge Street, Toronto, Ontario, Canada M4N 2M6. steve@earthfx.com
authors.forename: Steven G
authors.initials: SG
authors.lastname: Shikaze
authors.forename: Allan S
authors.initials: AS
authors.lastname: Crowe
mesh_terms: D000332:Aerobiosis; D000693:Anaerobiosis; D010575:Pesticides / Q000032:analysis*; D012984:Software; D014584:User-Computer Interface; D014873:Water Pollutants / Q000032:analysis*
chemical_list: D010575:Pesticides; D014873:Water Pollutants