Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create single chart with data from seperate worksheets | Charts and Charting in Excel | |||
able to automatically create a chart in Excel | Charts and Charting in Excel | |||
How to create a chart based on a 2 dim data range dynamical in 1 d | Charts and Charting in Excel | |||
Macro to Create a Chart and Update it Automatically | Charts and Charting in Excel | |||
Create a combo chart with two of the same chart types | Charts and Charting in Excel |