People Also Search. Tie Line Phase Diagram. Software Diagram. Ternary Graph Paper. Ternary Diagram Geology. Pyroxene Diagram. Ternary Plot. Binary Phase Diagram. Ni-Cr Phase Diagram. Two-Component Phase Diagram. Phase Diagram Example. Ammonia Phase Diagram. N2 Phase Diagram. Feldspar Ternary Diagram. Ternary Plot R.
Reading Phase Diagram. This sounds more complicated than it is. In the example I use here, I am using 3 columns for the original non-normalized geochemical data i. Then another 3 columns for the normalized values, and a fourth column for the sum of the previous three as a check option. This is followed by two columns, which will show the XY coordinates of the binary plot of the ternary diagram. We start with determining the coordinates for our ternary diagram apecis, i.
I put the sum of columns F, G, and H into column I i. Then drag the content of cells F4 to I4 down. Your spreadsheet should have the numbers in it like under the blue and green marked cells in Figure 5. In this case, that is right. You can test, however, if your cells are set up correctly, by replacing the entries with random numbers, the normalized values should stay the same. Double-check by additionally replacing a 0 in the non-normalized data with a random number too.
The normalized value should change accordingly, but the sum should still be Figure 6. The next step is to calculate the X and Y coordinates so we can plot the triangular ternary diagram. Copy the values of the calculated XY coordinates to a separate place in the spreadsheet so they are out of the way e.
Insert a Scatter Chart XY diagram , e. To make it into an equilateral triangle resize the chart area accordingly; for example 10 columns wide and 30 rows high, as in Figure Excel will automatically scale the X and Y axis from 0 to ; we need to change both axes to 0 to see Figure Next, we need some space for the apices labels: click into the Plot Area not the Chart Area then resize by holding the Shift key this ensures an equal scaling and use the mouse cursor on one of the corner pick-points.
Then recentre the Plot Area in the Chart Area. In this way, if you change the entry of the labels in cells F3 A , G3 B , and H3 C , it will automatically show in the diagram. Change the line color of the triangle if you like and adjust the line thickness, i. We start with the X-axis; like in an XY chart, add tick marks to the X-axis recommended type: Cross rather in Inside or Outside ; see below. Add two new data tables with coordinates and labels, as in Figure 13, to your Excel spreadsheet, e.
The data points will likely be displayed as a line. Change the color accordingly to those of the X-axis. You can change this, if you want, for instance, the labels in the opposite direction, by changing the Label Option Format Data Labels to Value From Cells , and then use the Select Range button to select the cells here the labels we wrote earlier.
In the final step, we add gridlines to the graph. We need to add another table with XY coordinates. I need to plot ternary diagrams, does anyone know of a addin?
I have been trying the addin of Julien Furrer "Trixcel". Two problems, instructions. Thanks a lot usama Ahmad sb. In my field Chem Eng , I use ternary diagrams to show phase diagram for three component mixtures.
0コメント