how to create a three variable chart.

[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.

 

[MrShorty]

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.

 

[Del Cotter]

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.

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

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