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). 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
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
Dear Joana. Something went wrong and I only found your comment now. Do you still need help? In case that, please contact me directly via [email protected] Reply
Thank you for reaching out. Glad to hear that it was of good help. Feedback is always welcome – Danke schön. Reply