(PS: I am planning to make the Excel spreadsheet available for downloading, but can currently not find the time to figure out how to do it. I hope that explains it and helps you to construct your own ternary diagram. As I understand you do not have problems with those steps. Thereafter (“Adding tick marks and …”), we simply mimic that style graphically for the other two axes. For instance I chose ‘Cross’, which means the tick marks cross the axis and you have the mark inside and outside. Here you can format the style of the ticks and numbers like in a ‘common’ XY-graph. The next step is to delete the Y-axis (“Cleaning up the Chart”). In Figure 12 you see that both, X and Y axes are visible. Remember, we ‘project’ a ternary diagram onto an XY-diagram/graph. It always helps to see where I can improve the description, as I am sure you are not the only one struggling with this. However, that’s a bit work intensive, because it needs to be done for each of the points in that set.)
For this you need to click on the data point, thus the whole series will be selected, and then click on it again, now only that point is selected and can be edited, e.g. (Alternatively to step 2, you can put the two sets together as per step 1 (either option 1 or 2), and then mark and change the appearance of the data points from one set manually. They should plot over / overlay the combined set, and thus you can differentiate them, e.g., with a different symbol or colour.ġ) Copy both data sets together, i.e. If you want those points only as symbols display them as ‘Scatter’ (i.e. Thus they will be treated as one set and can be connected (‘Scatter with straight line and marker’ or are you using trendlines? Doesn’t matter, same principle).Ģ) Add another ‘Data Series’ with just one of the two data sets and display in the diagram, too. We sorted it per email, but but I post the answer here again, so others may benefit from it:ġ) When you select the data for the diagram, mark the first set, then hold the Ctrl key and mark the second set.
This is the reply I wrote to Mark when his question came up a couple of weeks ago. If you have further questions, I can send you Screen Shots. I hope this helps to understand the process a bit better. The data should now be displayed in the ternary diagram, which is based on X and Y values only, as we interpolate the three components onto a binary diagram. Then click ‘OK’, and ‘Ok’ again on the ‘Select Data Source’ window. Click the ‘Add’ button.ĥ) A window opens called ‘Edit Series’ (I think here is the confusion in my description with “... >Edit Series”).Ħ) You can give the series a name and select the Series X values (which will be from column K) and the Series Y values (here from column L). Alternatively, you can copy cells F10 to L10 and paste them into the cells below for the extent you need).ģ) Now right-click into the diagram (a small window opens) and click on ‘Select Data’.Ĥ) A window opens called ‘Select Data Source’. Simply mark the last cells (i.e., F10 to L10) and then drag the little square at the lower right corner of the marked cells (your mouse cursor changes to a + when on it) down to where you need it. No problem here is a more detailed workflow for Step 3:ġ) You copy your data (non-normalized) to columns B, C, and D starting with row 4, i.e., below the blue headers (RAW DATA A’, B’, and C’).Ģ) You probably have to extend the range of columns F to I, and K and L, as they only have formulas down to row 10. I also tested the ternary diagram, as constructed here, extensively, and the data points plot exactly where they should be (see for instance the first three diagrams (Fig. As per Step 2, the triangle/ternary diagram has then been stretched, so it looks like an equilateral triangle again, which doesn’t affect the XY coordinate system behind it, as it is stretched with it.Ĭorrespondingly, due to the projection of A to Y (100 units), a factor of 0.86603 comes into play: tan(30°) = 0.57735 -> 0.57735 x 0.86603 = 0.5. 7).īecause A is projected to 100 units (rather than 86.60…), the triangle is elongated and the angle of 30 degrees changes to 26.56505 degrees unfortunately, Excel doesn’t plot diagrams in scale to show this. Thus, we can use the normalized A component as Y without a trigonometric function (Fig.
The ternary diagram ABC is projected into a cartesian XY graph.įor an equilateral triangle with a side length of 100 units (e.g., X-axis B-C side 0-100%), the height is 86.60254 units (i.e., Y-axis A).Ī is projected onto Y with 100 units. In the case here, however, it is a different approach: You are right with the tan(30°) statement for calculating the X coordinate in an equilateral triangle/ternary diagram.