A
ali
how can i creat a scatter plot matrix from a huge set of environmental data?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jerry W. Lewis
Excel can create the individual panes of a scatter plot matrix, but has
no native functionality to jointly product the entire matrix. You could
write a VBA macro to automate the process, or you could do it natively in R
www.r-product.org
the freely downloadable open source implementation of the S statistical
language.
There is even an interface that allows R routines to be called from Excel
http://cran.r-project.org/contrib/extra/dcom/RSrv135.html
Jerry
no native functionality to jointly product the entire matrix. You could
write a VBA macro to automate the process, or you could do it natively in R
www.r-product.org
the freely downloadable open source implementation of the S statistical
language.
There is even an interface that allows R routines to be called from Excel
http://cran.r-project.org/contrib/extra/dcom/RSrv135.html
Jerry
J
jahoobob
Highlight all the data and select Insert, Chart, and then pick Scatter
XY.
XY.
J
Jon Peltier
You don't even need VBA. You can set up some clever formulas in the
worksheet and use a stacked area chart for the colored background
rectangles, using a technique like this:
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
worksheet and use a stacked area chart for the colored background
rectangles, using a technique like this:
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
J
Jerry W. Lewis
Your directions would make a single scatter plot, not a scatter plot matrix
http://www.itl.nist.gov/div898/handbook/eda/section3/scatplma.htm
Jerry
http://www.itl.nist.gov/div898/handbook/eda/section3/scatplma.htm
Jerry
A
Andy Pope
J
Jon Peltier
Ignore my post. I misunderstood the question (and forgot to paste the
link to an irrelevant page).
Andy Pope's example is a good place to start (check his post).
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
link to an irrelevant page).
Andy Pope's example is a good place to start (check his post).
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______