Dear David, maybe I'm wrong, but I think the top coordination for the triangle should not be 100 if you want to have an equilateral triangle. Rather it should be 100Xcos(30°)=86.6.
Please can you send me the excel file. This is because the one I downloaded from the drive plotted the graph but the triangle and axis were missing. Your help is greatly appreciated. Thank you
Hello, I have a question, I want to use your template for a ternary chemistry diagram, the diagram itself works, however I am still wondering how did you arrive at the formula to transform to the x axis where it mentions right + (TOP/ 2)?
Really good question! I inherited the formula long ago and it miraculously works. I've tested it by hand plotting numerous points. Wikipedia provides a mathematical review on how Ternary diagram points are calculated, but I haven't quite been able to derive the simplified formula used in the spreadsheet. If you can figure it out, please let me know.
Thank you! How exactly do the tie lines work? I am trying to make a QAPF diagram. Also how would you invert the triangle to do the bottom half of a QAPF diagram.
Good questions Jesse. Drawing the inverted triangle is the easy part. On the right side of the worksheet there is a table called "Reference Lines," where I establish points that define the lines. Each line has two rows of data: a binging X Y and and ending X Y. Each line defined by these beginning and ending points are plotted t as a separate series. The difficult part in the the left-right normalization which I'm pondering at the moment. I'll let you know when I've figured it out.
Jesse, According to Wikipedia, Quartz and Feldspathoids don't or rarely co-exist in plutonic rocks, so the lower part of the plot is simply a mirror image of the Ternary plot. I have made a QFAP in Excel. Send me your email and I'll send you the Excel Workbook - my email is dmadvoc@gmail.com.
Added QFAP diagram with reference lines. To learn how to make reference lines, click on any of the reference lines to see where the data is coming from. Also, right click on the chart and go to "select data", there you can see how I added the reference lines. Hope this helps!
Seoul, What should download is an Excel workbook for plotting your own data into a Ternary Diagram. Send me you email address and I can email you the workbook - my email is dmadvoc@gmail.com
Simone, Thank you for your suggestion. It might be a while before I could get around to making the video that you suggest. In the mean time, I suggest you download the video (if you haven't already done so) and examine the formula's in the tables: you'll see that the trick is transforming three values into X-Y space, i.e. two values and then making a scatter chart. The triangle and reference lines are also scatter chart "series" that are plotted. I hope this brief explanation helps.
I'm not familiar with the Shepard and prejurp Ternary Plots, but I believe that it's just a matter of reference lines. In which case it can be easily done by creating and plotting new series to the existing chart that represent the reference lines. To add reference, look how the existing reference line series have already been added.
Hello David, this video is really helpful, thanks a lot for sharing. Can I please get a template for plotting pebble morphometric parameters. I've been searching for some for a while on the internet but I've been unsuccefully so far
Cobby, While I don't have any templates for morphometric parameters, you can easily modify the existing workbook for your own templates. Note that on the right side of the worksheets, there is a place for "Reference Lines." This is where you can enter the coordinates for new reference lines. If you haven't been able to successfully download the Ternary Plot Excel workbook, send me your email address and I sent the workbook to you.
hello there, i really want to make a new one , could u please tell me how to make it not only use it cause i need some modification, i download ur excel already but i didnt see where the data that can make that trenary , thx !
Ongky, Thanks for your question. Making the ternary diagram has two key elements: 1) Normalizing and transforming the data from three elements into two elements and plotting it on a scatter chart. The gray colored cells contain the formulas for normalizing and transforming the data. You can click in those cells and see the formulas; 2) This is the tricky part... Once you have created the scatter chart, you'll need to turn off the axes and labels (they are hidden). To the right of the ternary diagram, is a table with tree columns (Reference Lines) where the left column represents the SERIES names and the next two columns are the X and Y coordinates for the reference lines. Each SERIES us plotted separately on the ternary diagram. I hope this explanation works for you. Let me know if you have further questions.
Hello Kyaw, In the yellow cells, enter your raw data, for example a rock sample has 20% limestone, 10% shale, 50% sandstone and 20% salt. If you want limestone (left), sandstone (top) and shale (right), then enter 20, 50, and 10 in the yellow cells under "Raw Data". Notice that the gray and green cells will automatically calculate the normalized and transformed data. If you add more rows of data than currently in the worksheet, you will need to copy and past the gray and green cells down into the black columns. Next you will need to update the chart. There are many very good videos on scatter charts in Excel that will help you if you get stuck. Regards, Dave A.
I ment to say "copy and the gray and green cells down into the columns." Sorry about the typo's. Also, if you add more rows of data, you will need to right click on the charted data points to edit the data selection for the charts. There are many internet resources that demonstrate how to add data to scatter charts in Excel.
Thank you so much David! This saved me a lot of time :)
Dave - perfect just what I needed to adapt to my project!
Great, thank you very much, just what i need
Dear David, maybe I'm wrong, but I think the top coordination for the triangle should not be 100 if you want to have an equilateral triangle. Rather it should be 100Xcos(30°)=86.6.
Please how does this tinary graph work for sulphactant,co-sulphactant ,oil and water
Thanks for sharing this useful video and excel, man. Thanks a lot
many thanks. You saved me!!!
Thank you sooooooooooo much!!!!!
Thank you. You helped a lot. Good job!
This is amazing... Thank you so much
Exelente, muy muy útil. Like.
Excelent, very usfull. Thanks. Like
You are GOD! Thank uuuuuu!
That was wonderful. I really needed it. Thank you :)
Please can you send me the excel file. This is because the one I downloaded from the drive plotted the graph but the triangle and axis were missing. Your help is greatly appreciated. Thank you
Excelent, my friend!!!!
mano tu e god
te amo namoral me salvo
Thank you very much!
Thank you so much.
very useful.. thanks a lot
Hello, I have a question, I want to use your template for a ternary chemistry diagram, the diagram itself works, however I am still wondering how did you arrive at the formula to transform to the x axis where it mentions right + (TOP/ 2)?
Really good question! I inherited the formula long ago and it miraculously works. I've tested it by hand plotting numerous points. Wikipedia provides a mathematical review on how Ternary diagram points are calculated, but I haven't quite been able to derive the simplified formula used in the spreadsheet. If you can figure it out, please let me know.
@@williamlozano1624 hello’ sir the excel sheet it quit different from my indicators can you provide the example of three indicters simply
Thank you so much
Thank you! How exactly do the tie lines work? I am trying to make a QAPF diagram. Also how would you invert the triangle to do the bottom half of a QAPF diagram.
Good questions Jesse. Drawing the inverted triangle is the easy part. On the right side of the worksheet there is a table called "Reference Lines," where I establish points that define the lines. Each line has two rows of data: a binging X Y and and ending X Y. Each line defined by these beginning and ending points are plotted t as a separate series. The difficult part in the the left-right normalization which I'm pondering at the moment. I'll let you know when I've figured it out.
Jesse, According to Wikipedia, Quartz and Feldspathoids don't or rarely co-exist in plutonic rocks, so the lower part of the plot is simply a mirror image of the Ternary plot. I have made a QFAP in Excel. Send me your email and I'll send you the Excel Workbook - my email is dmadvoc@gmail.com.
Added QFAP diagram with reference lines. To learn how to make reference lines, click on any of the reference lines to see where the data is coming from. Also, right click on the chart and go to "select data", there you can see how I added the reference lines. Hope this helps!
Thank you!
Thanks a lot.....
this is amazing... thanks
thank you so much for share your khowledge
Please help me... Each time I download the Zip file. The ternary sheet plot does not Include the triangle plot. Instead it's a 2d diagram
Seoul, What should download is an Excel workbook for plotting your own data into a Ternary Diagram. Send me you email address and I can email you the workbook - my email is dmadvoc@gmail.com
Thank you
Good Video, can you make a new one, where you show how you plot this diagram? please it would be very nice!
Simone, Thank you for your suggestion. It might be a while before I could get around to making the video that you suggest. In the mean time, I suggest you download the video (if you haven't already done so) and examine the formula's in the tables: you'll see that the trick is transforming three values into X-Y space, i.e. two values and then making a scatter chart. The triangle and reference lines are also scatter chart "series" that are plotted. I hope this brief explanation helps.
@@davidadvocate5449 ooh OK, thank you, i will try it again :)
Thanks!
Can we plot Shepard,folk prejurp ternary diagram
I'm not familiar with the Shepard and prejurp Ternary Plots, but I believe that it's just a matter of reference lines. In which case it can be easily done by creating and plotting new series to the existing chart that represent the reference lines. To add reference, look how the existing reference line series have already been added.
Hello David, this video is really helpful, thanks a lot for sharing. Can I please get a template for plotting pebble morphometric parameters. I've been searching for some for a while on the internet but I've been unsuccefully so far
Cobby, While I don't have any templates for morphometric parameters, you can easily modify the existing workbook for your own templates. Note that on the right side of the worksheets, there is a place for "Reference Lines." This is where you can enter the coordinates for new reference lines. If you haven't been able to successfully download the Ternary Plot Excel workbook, send me your email address and I sent the workbook to you.
thanks
hello there, i really want to make a new one , could u please tell me how to make it not only use it cause i need some modification, i download ur excel already but i didnt see where the data that can make that trenary , thx !
Ongky, Thanks for your question. Making the ternary diagram has two key elements: 1) Normalizing and transforming the data from three elements into two elements and plotting it on a scatter chart. The gray colored cells contain the formulas for normalizing and transforming the data. You can click in those cells and see the formulas; 2) This is the tricky part... Once you have created the scatter chart, you'll need to turn off the axes and labels (they are hidden). To the right of the ternary diagram, is a table with tree columns (Reference Lines) where the left column represents the SERIES names and the next two columns are the X and Y coordinates for the reference lines. Each SERIES us plotted separately on the ternary diagram. I hope this explanation works for you. Let me know if you have further questions.
Hello, I really see that how to create the start of ternary diagram. What kinds of tools did you use? Thanks!
It is an excellent for us. So, how to put more raw data than A to H in you excel sheet. could you explain me in excel sheet. please.
Hello Kyaw, In the yellow cells, enter your raw data, for example a rock sample has 20% limestone, 10% shale, 50% sandstone and 20% salt. If you want limestone (left), sandstone (top) and shale (right), then enter 20, 50, and 10 in the yellow cells under "Raw Data". Notice that the gray and green cells will automatically calculate the normalized and transformed data. If you add more rows of data than currently in the worksheet, you will need to copy and past the gray and green cells down into the black columns. Next you will need to update the chart. There are many very good videos on scatter charts in Excel that will help you if you get stuck.
Regards,
Dave A.
I ment to say "copy and the gray and green cells down into the columns." Sorry about the typo's. Also, if you add more rows of data, you will need to right click on the charted data points to edit the data selection for the charts. There are many internet resources that demonstrate how to add data to scatter charts in Excel.
Where are the work sheet
Download using the link in the video description. If it doesn't work, reply with your email address and I send you a copy.