An Excel macro for generating trilinear plots |
| |
Authors: | Shikaze Steven G Crowe Allan S |
| |
Institution: | EarthFX Incorporated, 3363 Yonge Street, Toronto, Ontario, Canada M4N 2M6. steve@earthfx.com |
| |
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. |
| |
Keywords: | |
本文献已被 PubMed 等数据库收录! |
|