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?
>>
>>
>>