01/25/2025 1

TERNPLOT: TERNary PLOTting Excel 4.0 spreadsheet

A brief description of the spreadsheet can be found in cells P5-X31

The graph can be exploded to full screen size by double clicking on the
embedded graph located on top of cell I9

Modifiable plotting parameters

Min Max Incrmt Ticklen
A-axis 0.00 100.00 10.00 5.00
B-axis 0.00
Calcualted parameters DON'T CHANGE
B-axis 100.00 10.00 5.00
C-axis 0.00 100.00 10.00 5.00

Raw data X-Plot Y-Plot Normalised data

Plotting data (for chart) An Ab Or value value %A %B
90.00 10.00 0.00 33.75 90.00 90.00 10.00
90.00 10.00 10.00 37.50 81.82 81.82 9.09
90.00 0.00 10.00 41.25 90.00 90.00 0.00
90.00 10.00 10.00 37.50 81.82 81.82 9.09
70.00 30.00 10.00 30.68 63.64 63.64 27.27
70.00 30.00 0.00 26.25 70.00 70.00 30.00
70.00 30.00 10.00 30.68 63.64 63.64 27.27
50.00 50.00 10.00 23.86 45.45 45.45 45.45
50.00 50.00 0.00 18.75 50.00 50.00 50.00
50.00 50.00 10.00 23.86 45.45 45.45 45.45
40.00 60.00 10.00 20.45 36.36 36.36 54.55
37.00 63.00 12.00 20.42 33.04 33.04 56.25
37.00 63.00 12.00 20.42 33.04 33.04 56.25
31.00 68.00 16.00 20.54 26.96 26.96 59.13
31.00 70.00 17.00 20.66 26.27 26.27 59.32
31.00 70.00 0.00 11.51 30.69 30.69 69.31
31.00 70.00 17.00 20.66 26.27 26.27 59.32
16.00 84.00 15.00 15.00 13.91 13.91 73.04
10.00 90.00 10.00 10.23 9.09 9.09 81.82

con't
01/25/2025 2

10.00 90.00 0.00 3.75 10.00 10.00 90.00

10.00 90.00 10.00 10.23 9.09 9.09 81.82
0.00 100.00 10.00 6.82 0.00 0.00 90.91
10.00 0.00 100.00 71.59 9.09 9.09 0.00
10.00 60.00 40.00 30.68 9.09 9.09 54.55
12.20 65.00 35.00 27.47 10.87 10.87 57.93
17.00 70.00 30.00 24.68 14.53 14.53 59.83
23.00 75.00 25.00 22.26 18.70 18.70 60.98
35.00 81.00 20.00 20.68 25.74 25.74 59.56

15.00 90.00 54.00 29.01 9.43 9.43 56.60

0.00 90.00 54.00 28.13 0.00 0.00 62.50

Sample number (enter data below) An Ab Or

Example 1 20.00 70.00 10.00 15.00 20.00 20.00 70.00
Example 2 30.00 45.00 5.00 18.75 37.50 37.50 56.25
Example 3 60.00 20.00 5.00 30.88 70.59 70.59 23.53

con't
01/25/2025 3

con't
01/25/2025 4

A B
37.50 ### ### 0.00
0.00 0.00 0.00 ###
75.00 0.00 0.00 0.00
37.50 ### ### 0.00

115.47

con't
 01/25/2025 5

TERNPLOT USE
Marshall, Daniel (1996), Ternplot: An Excel spreadsheet for Ternary diagrams, Comput

1. Place your data in the columns titled A,B,C, (excel columns B,C & D)
Axes are as: A
/_\
B C
Titles A,B & C can be replaced with your titles for clarity

2. All the calculations are within cells F14:I14 you will have to copy these

Five cells for each row of data you wish to plot

rmalised data
%C
0.00
9.09 TERNPLOT LIMITS
10.00
9.09 1. You are limited to about 300 data points the way it's set up,
9.09 but it's easy to change that. Just use the insert command (shift cells down)
0.00 to add more rows above the triangle outline/labels data cells
9.09 which are at about cell F330 on. Excel should automatically increase the
9.09 the graph ranges to include the new rows and the triangle outline data
0.00
9.09 2. Due to Excels ecentricities between the position of objects on the screeen
9.09 and where they appear on the hardcopy it is difficult to place field boundaries
10.71 using the drawing tools in Chart. However, one can digitize the field boundaries
10.71 and then put the data in the column that draws the triangle outlines.
13.91 Importing the ternary plot to drawing programs such as Corel Draw can be done via the
14.41 Use Paste Special (Picture) in Corel Draw to paste the graph from the Clipboard
0.00
14.41
13.04
9.09
An

con't
01/25/2025 6

0.00 An
9.09
9.09
90.91
36.36
31.19
25.64

e
20.33

ni t
t ow
14.71

By
33.96
37.50

rite
do
bra
La
10.00
6.25
5.88

e
sin
de
An
se
cla
go
oli

Anorthoclase Sanidine
ite
A lb

Ab Or

con't
01/25/2025 7

con't
01/25/2025 8

C
0.00
0.00
###
0.00

con't
 01/25/2025 9

r Ternary diagrams, Computers and Geosciences, vol. 22 #6, p. 697-699.

lumns B,C & D)

ave to copy these

shift cells down)

increase the
utline data

cts on the screeen

ace field boundaries
e the field boundaries
outlines.
l Draw can be done via the clipboard
h from the Clipboard

con't
01/25/2025 10

Or

con't
01/25/2025 11

con't
01/25/2025 12

###
0.00
0.00
###

These data points are

required for the triangle lines
DO NOT REMOVE

con't
01/25/2025 13

A-B ticks
A B C X Y
10.00 85.00 5.00 0.00 10.00
10.00 90.00 0.00 3.75 10.00
5.00 90.00 5.00 5.63 5.00

20.00 75.00 5.00 0.00 20.00

20.00 80.00 0.00 7.50 20.00
15.00 80.00 5.00 9.38 15.00

30.00 65.00 5.00 0.00 30.00

30.00 70.00 0.00 11.25 30.00
25.00 70.00 5.00 13.13 25.00

40.00 55.00 5.00 0.00 40.00

40.00 60.00 0.00 15.00 40.00
35.00 60.00 5.00 16.88 35.00

50.00 45.00 5.00 0.00 50.00

50.00 50.00 0.00 18.75 50.00

con't
01/25/2025 14

45.00 50.00 5.00 20.63 45.00

60.00 35.00 5.00 0.00 60.00

60.00 40.00 0.00 22.50 60.00
55.00 40.00 5.00 24.38 55.00

70.00 25.00 5.00 0.00 70.00

70.00 30.00 0.00 26.25 70.00
65.00 30.00 5.00 28.13 65.00

80.00 15.00 5.00 0.00 80.00

80.00 20.00 0.00 30.00 80.00
75.00 20.00 5.00 31.88 75.00

90.00 5.00 5.00 0.00 90.00

90.00 10.00 0.00 33.75 90.00
85.00 10.00 5.00 35.63 85.00

10.00 5.00 5.00 0.00 10.00

10.00 10.00 0.00 3.75 10.00
5.00 10.00 5.00 5.63 5.00

20.00 5.00 5.00 0.00 20.00

20.00 10.00 0.00 7.50 20.00
15.00 10.00 5.00 9.38 15.00

30.00 5.00 5.00 0.00 30.00

30.00 10.00 0.00 11.25 30.00
25.00 10.00 5.00 13.13 25.00

con't
01/25/2025 15

10.00 5.00 85.00 67.50 10.00

10.00 0.00 90.00 71.25 10.00
5.00 5.00 90.00 45.00 0.00

20.00 5.00 75.00 63.75 20.00

20.00 0.00 80.00 67.50 20.00
15.00 5.00 80.00 37.50 0.00

30.00 5.00 65.00 60.00 30.00

30.00 0.00 70.00 63.75 30.00

con't
01/25/2025 16

25.00 5.00 70.00 30.00 0.00

40.00 5.00 55.00 56.25 40.00

40.00 0.00 60.00 60.00 40.00
35.00 5.00 60.00 22.50 0.00

50.00 5.00 45.00 52.50 50.00

50.00 0.00 50.00 56.25 50.00
45.00 5.00 50.00 15.00 0.00

60.00 5.00 35.00 48.75 60.00

60.00 0.00 40.00 52.50 60.00
55.00 5.00 40.00 7.50 0.00

70.00 5.00 25.00 45.00 70.00

70.00 0.00 30.00 48.75 70.00
65.00 5.00 30.00 67.50 0.00

80.00 5.00 15.00 41.25 80.00

80.00 0.00 20.00 45.00 80.00
75.00 5.00 20.00 60.00 0.00

90.00 5.00 5.00 37.50 90.00

90.00 0.00 10.00 41.25 90.00
85.00 5.00 10.00 52.50 0.00

10.00 5.00 85.00 67.50 10.00

10.00 0.00 90.00 71.25 10.00
5.00 5.00 90.00 45.00 0.00

20.00 5.00 75.00 63.75 20.00

20.00 0.00 80.00 67.50 20.00
15.00 5.00 80.00 37.50 0.00

30.00 5.00 65.00 60.00 30.00

con't
01/25/2025 17

30.00 0.00 70.00 63.75 30.00

25.00 5.00 70.00 30.00 0.00

Ticks on the line B-C

5.00 10.00 85.00 33.75 90.00

0.00 10.00 90.00 67.50 0.00
5.00 5.00 90.00 69.38 5.00

5.00 10.00 75.00 30.00 80.00

0.00 20.00 80.00 60.00 0.00
5.00 15.00 80.00 61.88 5.00

5.00 10.00 65.00 26.25 70.00

0.00 30.00 70.00 52.50 0.00
5.00 25.00 70.00 54.38 5.00

5.00 10.00 55.00 22.50 60.00

0.00 40.00 60.00 45.00 0.00
5.00 35.00 60.00 46.88 5.00

5.00 10.00 45.00 18.75 50.00

0.00 50.00 50.00 37.50 0.00
5.00 45.00 50.00 39.38 5.00

5.00 10.00 35.00 15.00 40.00

0.00 60.00 40.00 30.00 0.00
5.00 55.00 40.00 31.88 5.00

5.00 10.00 25.00 11.25 30.00

0.00 70.00 30.00 22.50 0.00
5.00 65.00 30.00 24.38 5.00

5.00 10.00 15.00 7.50 20.00

0.00 80.00 20.00 15.00 0.00

con't
01/25/2025 18

5.00 75.00 20.00 16.88 5.00

5.00 10.00 5.00 3.75 10.00

0.00 90.00 10.00 7.50 0.00
5.00 85.00 10.00 9.38 5.00

5.00 10.00 85.00 33.75 90.00

0.00 10.00 90.00 67.50 0.00
5.00 5.00 90.00 69.38 5.00

5.00 10.00 75.00 30.00 80.00

0.00 20.00 80.00 60.00 0.00
5.00 15.00 80.00 61.88 5.00

5.00 10.00 65.00 26.25 70.00

0.00 30.00 70.00 52.50 0.00
5.00 25.00 70.00 54.38 5.00

5.00 10.00 55.00 22.50 60.00

0.00 40.00 60.00 45.00 0.00
5.00 35.00 60.00 46.88 5.00

5.00 10.00 45.00 18.75 50.00

0.00 50.00 50.00 37.50 0.00
5.00 45.00 50.00 39.38 5.00

5.00 10.00 35.00 15.00 40.00

0.00 60.00 40.00 30.00 0.00
5.00 55.00 40.00 31.88 5.00

5.00 10.00 25.00 11.25 30.00

0.00 70.00 30.00 22.50 0.00
5.00 65.00 30.00 24.38 5.00

5.00 10.00 15.00 7.50 20.00

con't
01/25/2025 19

0.00 80.00 20.00 15.00 0.00

5.00 75.00 20.00 16.88 5.00

5.00 10.00 5.00 3.75 10.00

0.00 90.00 10.00 7.50 0.00
5.00 85.00 10.00 9.38 5.00

5.00 10.00 85.00 33.75 90.00

0.00 10.00 90.00 67.50 0.00
5.00 5.00 90.00 69.38 5.00

5.00 10.00 75.00 30.00 80.00

0.00 20.00 80.00 60.00 0.00
5.00 15.00 80.00 61.88 5.00

5.00 10.00 65.00 26.25 70.00

0.00 30.00 70.00 52.50 0.00
5.00 25.00 70.00 54.38 5.00

5.00 10.00 55.00 22.50 60.00

0.00 40.00 60.00 45.00 0.00
5.00 35.00 60.00 46.88 5.00

5.00 10.00 45.00 18.75 50.00

0.00 50.00 50.00 37.50 0.00
5.00 45.00 50.00 39.38 5.00

5.00 10.00 35.00 15.00 40.00

0.00 60.00 40.00 30.00 0.00
5.00 55.00 40.00 31.88 5.00

Tick positions line A-B descending order

used for the maximum tick length calculations

90.00 10.00 0.00 33.75 90.00

con't
 01/25/2025 20

80.00 20.00 0.00 30.00 80.00

70.00 30.00 0.00 26.25 70.00

60.00 40.00 0.00 22.50 60.00

50.00 50.00 0.00 18.75 50.00

40.00 60.00 0.00 15.00 40.00

30.00 70.00 0.00 11.25 30.00

20.00 80.00 0.00 7.50 20.00

data points are

or the triangle lines
O NOT REMOVE 10.00 90.00 0.00 3.75 10.00

con't
01/25/2025 21

90.00 10.00 0.00 33.75 90.00

80.00 20.00 0.00 30.00 80.00

70.00 30.00 0.00 26.25 70.00

60.00 40.00 0.00 22.50 60.00

50.00 50.00 0.00 18.75 50.00

40.00 60.00 0.00 15.00 40.00

30.00 70.00 0.00 11.25 30.00

20.00 80.00 0.00 7.50 20.00

10.00 90.00 0.00 3.75 10.00

con't
01/25/2025 22

90.00 10.00 0.00 33.75 90.00

80.00 20.00 0.00 30.00 80.00

70.00 30.00 0.00 26.25 70.00

60.00 40.00 0.00 22.50 60.00

50.00 50.00 0.00 18.75 50.00

40.00 60.00 0.00 15.00 40.00

con't