how to create a three variable chart.

  • Thread starter Thread starter ezequiel.monteagudo
  • Start date Start date
E

ezequiel.monteagudo

I am trying to create a three variable chart, does anyone know how to
do it?, the three ones are percents, for instance, when a variable is
90%, the two other have to complete the 10 %left, and so on.
 
What you are asking for sounds like a ternary plot. I'm pretty sure
there are utilities out there for making ternary plots. They are
pretty easy to create in Excel -- you just need to do the geometry to
figure out the transformations for transposing the triangular grid onto
the square grid that Excel uses. Then apply the transformation to your
data, add a few dummy series to plot axes and/or gridlines, and
whatever else you need.
 
What you are asking for sounds like a ternary plot. I'm pretty sure
there are utilities out there for making ternary plots. They are
pretty easy to create in Excel -- you just need to do the geometry to
figure out the transformations for transposing the triangular grid onto
the square grid that Excel uses. Then apply the transformation to your
data, add a few dummy series to plot axes and/or gridlines, and
whatever else you need.
Click to expand...

Here's one from the web site of Portland State University's Geology
Department

http://www.geologynet.com/programs/ternplot.xls
 
Back
Top