Scatterplot Matrix in Excel (12x12)
Small multiples—a phrase coined by Edward Tufte—is a series of small frames sharing the same graphical design structure, yet showing different data as the eye moves from one panel to the next.
Small multiples are efficient architecture for showing a large amount of multivariate data all in one eye span—hence enabling comparisons.
Unfortunately, Excel charting library doesn't include native small multiples. Users are either obliged to resort to VBA or to take the time consuming task of creating each and every chart, formatting them and arranging them in a suitable way to show patterns. If the data changes, the process has to be repeated. Not fun. Not Efficient.
So here I'm offering you an Excel template that takes a data set as an input and creates a scatterplot matrix with the following capabilities:
- Handles up to 12 variables (12x12 matrix)
- Displays the regression line in each panel
- Displays the correlation matrix in graphical format
- Evaluates the statistical model for user-selected variables
- Displays the 6-Plot charts—6 charts needed for assessment of the fit of regression analysis
- Data entered into Excel Table—hence the charts and formulas update automatically when the datasource expands or shrinks
- Define the scales (tick-mark spacing) and their number formatting
- Rearrange the order of the variables in the scatterplot matrix
- Define the number of panels to be displayed in the scatterplot matrix
- Adjust the margin from the edges of the panels to the data
- User-friendly interface to adjust the above settings
- Fully customizable chart using standard Excel formatting capabilities
- Unlocked workbook/worksheets with ability to expand template to suit your needs
- The size of the data matrix is only limited by Excel's charting and calculating capabilities
System requirements
The template relies heavily on Excel's Dynamic Arrays capabilities, only available to Microsoft 365 subscribers.
What's the refund policy?
If what you see is not what you expected, just reply to the download email within 30 days, and you'll get a full refund. No questions asked.
A native Excel template enabling business analysts, scientists, statisticians, data visualizers and journalists to produce scatterplot matrices in Excel along with the correlation matrix in graphic form. Moreover, the Excel template generates the statistical model along with the 6-Plot—a collection of 6 specific graphical techniques whose purpose is to assess the validity of a Y versus X fit.