scatter plot matrix ?

[ali]

how can i creat a scatter plot matrix from a huge set of environmental data?

 

[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

 

[jahoobob]

Highlight all the data and select Insert, Chart, and then pick Scatter
XY.

 

[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/
_______

 

[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

 

[Andy Pope]

Hi,

Not sure if this will help.
http://www.andypope.info/charts/miniplot_xy.htm

Cheers
Andy

 

[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/
_______