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

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/ex...m/RSrv135.html

Jerry

ali wrote:

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

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 wrote:

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/ex...m/RSrv135.html

Jerry

ali wrote:

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

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


Jon Peltier wrote:
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 wrote:

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/ex...m/RSrv135.html

Jerry

ali wrote:

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

Highlight all the data and select Insert, Chart, and then pick Scatter
XY.
ali Wrote:
how can i creat a scatter plot matrix from a huge set of environmental
data?


--
jahoobob

Your directions would make a single scatter plot, not a scatter plot matrix
http://www.itl.nist.gov/div898/handb...3/scatplma.htm

Jerry

jahoobob wrote:

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

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

Hi,

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

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info