May 22, 2011

Trilinear plots in excel

Here is an excel spreadsheet that allows you to plot and manipulate various series of water quality data on a piper/trilinear plot. No more purchasing of expensive software to do this and it is completely customizable following your basic excel knowledge to change symbol format, legend, and groupings of samples. Have fun!

Trilinear Plot in Excel (download from google docs)

8 comments:

  1. Just what I was looking for, thanks. Works perfectly.

    ReplyDelete
  2. This looks great. Thanks. How would you like this acknowledged in a report?
    Paul(NGO, Queensland, Australia)

    ReplyDelete
  3. Just been trying this out, but having entered my new data and pressed the recalculate function on each page, the final plot stays the same as the example in the downloaded sheet. What am I doing wrong?

    ReplyDelete
  4. Make sure you add group numbers

    ReplyDelete
  5. What are the group numbers based off of? I have 27 wells I want to put on the diagram. Is each well a separate group?

    ReplyDelete
  6. I can't download it. Is it removed from google docs?

    ReplyDelete
  7. Looking for the download! Plse put it up again?

    ReplyDelete
    Replies
    1. Not sure if you found a solution but if not try www.piperdiagram.com, its a web app to create piper diagrams.

      Delete

Please share your thoughts...