Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

An Excel macro for generating trilinear plots.

Steven G Shikaze1, Allan S Crowe

  • 1EarthFX Incorporated, 3363 Yonge Street, Toronto, Ontario, Canada M4N 2M6. steve@earthfx.com

Ground Water
|January 30, 2007
PubMed
Summary
This summary is machine-generated.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Anthropogenic impacts on a bedrock aquifer at the village scale.

Ground water·2013
Same author

Animating ground water levels with Excel.

Ground water·2003
Same journal

Leaky Sewers Hydraulically Disconnect from Groundwater: A Proof-of-Concept.

Ground water·2026
Same journal

Python-Based Model Emulation Workflows with PEST.

Ground water·2026
Same journal

Hydrogeology in the Age of AI and Climate Change.

Ground water·2026
Same journal

Aquifer Thermal Energy Storage: Groundwater for Efficient Data Center Cooling in the United States.

Ground water·2026
Same journal

Simulating the Impacts of Deep Geothermal Development on Shallow Hydrothermal Resources in a Rocky Mountain Rift Valley.

Ground water·2026
Same journal

Discharge-Targeted Hydraulic Tomography to Quantify and Locate Aquifer Discharge.

Ground water·2026
See all related articles

This study introduces a Visual Basic for Applications (VBA) macro for Microsoft Excel, enabling users to quickly generate trilinear plots from percentage data. This cost-effective method simplifies data visualization for scientific applications.

Area of Science:

  • Computer Science
  • Data Visualization
  • Scientific Software

Background:

  • Trilinear plots are essential for visualizing ternary data in various scientific fields.
  • Existing methods for creating trilinear plots can be complex or require specialized software.

Purpose of the Study:

  • To develop an accessible and efficient method for generating trilinear plots using readily available software.
  • To provide a user-friendly tool for converting ternary percentage data into a visual format.

Main Methods:

  • Development of a Visual Basic for Applications (VBA) macro within Microsoft Excel.
  • Implementation of a user interface for data input from Excel worksheets.
  • Automated conversion of three-column percentage data into X-Y coordinates.

Related Experiment Videos

  • Generation of plot axes, labels, and grid lines using Excel's charting capabilities.
  • Plotting of converted data as scatter plots within Excel.

    • Main Results:

    • A functional VBA macro capable of creating trilinear plots directly within Microsoft Excel.
    • Successful conversion of triangular percentage data into plottable X-Y data.
    • Generation of accurate and customizable trilinear plots with standard Excel features.

    Conclusions:

    • The developed VBA macro offers a quick, inexpensive, and user-friendly solution for creating trilinear plots.
    • This method enhances data visualization capabilities for users working with ternary datasets in Excel.
    • The tool democratizes the creation of trilinear plots, making it accessible to a wider range of scientific users.