Published August 23, 2025 | Version v5
Software Open

ternary diagram and quadrilateral diagram template for Excel

Authors/Creators

  • 1. KIT

Description

Excel template for plotting data into a triangular and a quadrilateral diagram. The sample data can be arranged in up to 15 groups that will be displayed with different symbols/colours in the diagrams.
Apart from data points, the user can define lines, fields and curves (open and closed) to map out areas in the diagram. Many data-sets are provided as examples.

Version 1.1: quadrilateral plot added

Version 1.2: "generic_triangular_diagram_2025_07":

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.

 

Version 1.3: "generic_triangular_diagram_2025-08.xlsm": for the quadrilateral diagram a lower cutoff value was added

Version 1.3.1: "generic_triangular_diagram_2025-08-2.xlsm": bug fix for the display of names of fields and curves

Notes

Tested with Excel 2019 for Mac and Windows.

Files

Files (1.6 MB)

Name Size Download all
md5:96595be490cc5baccabbf3ce997ca99f
1.6 MB Download

Additional details