Chrissy Wissy -

You wrote: It is quite hard to find an application that can plot a
correlation matrix in its normal form. The only way with Excel in its bare
form as I see it is to convert the matrix into a very long list of x
(variable), y (variable), z (correlation coefficient) values! <

No, it's not hard. Excel's 3-D Column chart type and Surface chart type use
worksheet data in what you have called "normal form."

That is, X values across the top, Y values down the left side, and Z values
in the body of the table.

If the data is in list (database) form, i.e., a row for each x, y, and z
value, you can use the Pivot Table feature to put it into a table for
charting.

Jon Peltier has an article at
http://pubs.logicalexpressions.com/P...cle.asp?ID=447

- Mike

www.MikeMiddleton.com