how can i creat a scatter plot matrix from a huge set of environmental data?
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?
>
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
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?
>
>
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
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?
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks