There is a newer version of the record available.

Published July 5, 2025 | Version v4
Software Open

Excel template to plot hydrochemical data into a Piper diagram

Authors/Creators

  • 1. KIT

Description

The water sample data can be arranged in up to 15 groups (version 1.1, May 25, 2022) that will be displayed with different symbols/colours in the three diagrams. Individual groups can be easily turned on/off for display.

Version "Piper_Diagram_2025-07.xlsm":

This version comes with a VBA macro that only inserts additional rows in order to accomodate more samples in a group. You don't need to enable the macro if you are happy with the number of pre-defined samples.

Notes

Tested with Excel 2019 for Mac and Windows.

Files

Files (1.5 MB)

Name Size Download all
md5:d4f90e17369ac60aa6cca9a763ecd3ce
1.5 MB Download

Additional details

References