A Knowledge Database for Applied Chemostratigraphy

how-to-plot-a-ternary-diagram-in-excel

AddOns for plotting a Ternary Diagram in Excel

Below are the coordinates for the grid lines for the ternary diagram from my article How to plot a Ternary Diagram in Excel (like in Figure 19, columns AA and AB rows 25 to 104).

ternary-gridlines
Figure 19: Adding gridlines to the ternary diagram.

The coordinates can be copied and pasted from here. Make sure that there are empty cells in every third row.

Ternary_Grid_Lines

X Y
45 90
55 90
40 80
60 80
35 70
65 70
30 60
70 60
25 50
75 50
20 40
80 40
15 30
85 30
10 20
90 20
5 10
95 10
95 10
90 0
90 20
80 0
85 30
70 0
80 40
60 0
75 50
50 0
70 60
40 0
65 70
30 0
60 80
20 0
55 90
10 0
5 10
10 0
10 20
20 0
15 30
30 0
20 40
40 0
25 50
50 0
30 60
60 0
35 70
70 0
40 80
80 0
45 90
90 0

3 thoughts on AddOns for plotting a Ternary Diagram in Excel

  1. First of all, great tutorial!!

    I cannot do the step pf the gridlines, it just appears dots on the x-axis. I dont know what Im doing wrong. Can you help me?

    Thank you!!!

    Reply

    1. Thank you for reaching out. Glad to hear that it was of good help. Feedback is always welcome – Danke schön.

      Reply

Add Your Comment

* Indicates Required Field

Your email address will not be published.

*