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.


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

On Tue, 23 May 2006, in microsoft.public.excel.charting,
MrShorty <(E-Mail Removed)> 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 (E-Mail Removed),
which goes to a spam folder-- please send your email to del3 instead.