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?