ternary diagram and quadrilateral diagram template for Excel
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
Files
Files
(1.6 MB)
| Name | Size | Download all |
|---|---|---|
|
md5:96595be490cc5baccabbf3ce997ca99f
|
1.6 MB | Download |