Excel charts
with Dynamic Arrays 031:
Scatterplot Matrix

This is the translation of an amazing blogpost and outstanding work from Hicham Bou Habib CCIM, MRICS. His post on this invaluable chart type led me to recreate it with dynamic arrays so it can be interactive. You can select specific variables, along with highlighting or “brushing” on what’s been filtered on the visual. Please do check out his blog 👉 https://lnkd.in/dESYZ5et | his Excel chart gallery is amazing! voilà! 👌 The logic on how to lay out the scatter plot matrix in Excel is well explained on his post. And my contribution has been only to convert those formulas to Dynamic Arrays. Again, Hicham thank you!

Track ID: Jon Rundell – Can’t Stop w/ Ultra Naté – Free (Acappella)

“But what’s scatter plot matrix?” as quoted from Hicham’s post:

“Scatterplot matrices are an excellent architecture for displaying large amounts of hypervariate data. Edward Tufte named this type of “multi-window plot” the most ingenious design. William Cleveland proposed giving an award to the (unknown) inventor of the scatterplot matrix and here is what he had to say about this graphical method:

“The inventor may not have fully appreciated the significance of the method or may have thought the idea too trivial to bring forward, but its simple, elegant solution to a difficult problem is one of the best graphical ideas around for displaying scattered measurements of three or more variables.”

The basic concept of the scatterplot matrix is simple. Given a set of N variables, the scatterplot matrix is a N*N matrix containing all the pairwise scatterplots of the N variables in a single eye span—hence enabling comparisons.”

And finally, I don’t make data graphics for the masses to watch to. I make data graphics for the small majority that want to see. Quote re-adapted from DJ Moodymann: “I don’t make music for the masses to dance to. I make music for the small majority that listens.”