I have Excel2003 and I need some way to form triangular/ternary charts.
Is there any way, or is there some plug-in available?
Please help, Frank
I have Excel2003 and I need some way to form triangular/ternary charts.
Is there any way, or is there some plug-in available?
Please help, Frank
Hi,
Here are some links, from previous posts, on ternary plots.
http://www.sfu.ca/~marshall/ternplot.htm
http://www.uni-wuerzburg.de/mineralo...g/ternary.html
http://www.geologynet.com/programs/ternplot.xls
ftp://www-sst.unil.ch/ftp/jfurrer/Trix_fr.zip
Cheers
Andy
Frank Martin wrote:
> I have Excel2003 and I need some way to form triangular/ternary charts.
>
> Is there any way, or is there some plug-in available?
>
> Please help, Frank
>
>
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
In big hurry, so I'll be terse. There are (of course three:
1. Trixcel:
http://www-sst.unil.ch/perso_pages/j...el/Trixcel.htm
(or Google for links to it and comments; it's in French but should be
self-explanatory; I remember there was also an English version XTXC, can't
remember whether older or newer than Trixcel)
OK, JUST FOUND IT: for link to XTXC go to
http://www.agri.upm.edu.my/~chris/tal/talxl.html
2. Ternplot: has an article "TernPlot: an Excel spreadsheet" in Computers
and Geosciences; find the file itself by means of Google yourself
3. tri-plot: http://www.lboro.ac.uk/research/phys-geog/tri-plot/
Best regards,
Gaj Vidmar
Uiv. of Ljubljana, Fac. of Medicine, Inst. of Biomedical Informatics
"Frank Martin" <[email protected]> wrote in message
news:[email protected]...
> I have Excel2003 and I need some way to form triangular/ternary charts.
>
> Is there any way, or is there some plug-in available?
>
> Please help, Frank
Many thanks to all. I'll check these out.
Regards, Frank
"Gaj Vidmar" <[email protected]> wrote in message
news:[email protected]...
> In big hurry, so I'll be terse. There are (of course three:
>
> 1. Trixcel:
> http://www-sst.unil.ch/perso_pages/j...el/Trixcel.htm
>
> (or Google for links to it and comments; it's in French but should be
> self-explanatory; I remember there was also an English version XTXC, can't
> remember whether older or newer than Trixcel)
>
> OK, JUST FOUND IT: for link to XTXC go to
> http://www.agri.upm.edu.my/~chris/tal/talxl.html
>
> 2. Ternplot: has an article "TernPlot: an Excel spreadsheet" in Computers
> and Geosciences; find the file itself by means of Google yourself
>
> 3. tri-plot: http://www.lboro.ac.uk/research/phys-geog/tri-plot/
>
> Best regards,
>
> Gaj Vidmar
> Uiv. of Ljubljana, Fac. of Medicine, Inst. of Biomedical Informatics
>
> "Frank Martin" <[email protected]> wrote in message
> news:[email protected]...
>> I have Excel2003 and I need some way to form triangular/ternary charts.
>>
>> Is there any way, or is there some plug-in available?
>>
>> Please help, Frank
>
>
[Frank Martin] scrive in
http://www.google.it/[email protected]
> I have Excel2003 and I need some way to form triangular/ternary
> charts.
> Is there any way, or is there some plug-in available?
http://www.prodomosua.it/zips/triangolare.xls
.f
Hi,
Make an XY-scatter plot with the following data (Series 1, shown as x,
y-pairs); this forms the triangular boundary. Format the line to suit to
your taste. In “Chart Options”/ “Axes” Tab, uncheck X- and Y- axes to hide
them. Similarly get rid of the borders of the plot and chart areas, and
resize the areas to get a triangle that looks ‘equilateral’ on the screen (!)
Series 1:
0.0, 0.00
0.5, 0.86603
1.0, 0.00
0.0, 0.00
Add 5 more series to the above graph with the following data (these form the
grids; format the lines appropriately)
Series 2:
0.05, 0.086603
0.10, 0.00
0.55, 0.77942
0.45, 0.77942
0.90, 0.00
0.95, 0.086603
0.05, 0.086603
Series 3:
0.10, 0.17321
0.20, 0.00
0.60, 0.69282
0.40, 0.69282
0.80, 0.00
0.90, 0.17321
0.10, 0.17321
Series 4:
0.15, 0.25981
0.30, 0.00
0.65, 0.60622
0.35, 0.60622
0.70, 0.00
0.85, 0.25981
0.15, 0.25981
Series 5:
0.20, 0.34641
0.40, 0.00
0.70, 0.51962
0.30, 0.51962
0.60, 0.00
0.80, 0.34641
0.20, 0.34641
Series 6:
0.25, 0.43301
0.50, 0.00
0.75, 0.43301
0.25, 0.43301
Plotting the data:
Please note that the above approach assumes that the compositions of ternary
mixtures are expressed in terms of the fraction (and not percentage) of
components A and B (i.e., fA and fB); so fC = 1-fA-fB.
In say A21….. and B21 ….., enter fA and fB respectively. In C21 enter the
formula = 1-A21-B21 (This column is only for completeness and is not really
necessary for the plot. However, if you do create this column, you could
simplify the formulas below by replacing “(1-A21-B21)” with “C21”).
In D21 enter the formula, =B21+(1-A21-B21)*COS(PI()/3) [x-value of the
data point]
In E21 enter the formula, =(1-A21-B21)*SIN(PI()/3) [y-value of the data
point]
Auto-fill the formulas down to the last row.
Add a series to the blank ternary plot area you have already created, with
E21:Elastrow (y-range) vs D21:Dlastrow (x-range).
The left-hand-side bottom, right-hand-side bottom and the top corners of the
triangle correspond to pure A, B, and C respectively.
Regards,
B. R. Ramachandran
"Frank Martin" wrote:
> I have Excel2003 and I need some way to form triangular/ternary charts.
>
> Is there any way, or is there some plug-in available?
>
> Please help, Frank
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks