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?