how to create a three variable chart.
 

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.

how to create a three variable chart.
 

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.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=544711

Ternary chart (was how to create a three variable chart)
 

On Tue, 23 May 2006, in microsoft.public.excel.charting,
MrShorty said:

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

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.