Last version published: 07/04/2021 09:50
Publication number: ELQ-38780-4
View all versions & Certificate
Scatter Plot Matrix in Excel (12x12 panels) with Correlation Matrix
Excel template to build a Scatterplot Matrix—with up to 12 variables—in one chart for ease of analysis and formatting.
Acquire consulting license for $25.00
Add to cart
Add to bookmarks
To enable 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.
Business, science, statistics, data visualization, data journalism
Template relies heavily on Excel's Dynamic Arrays capabilities, only available to Office 365 subscribers.
Write a review
People using this Best Practice also downloaded
Hotel Performance Dashboard in ExcelExcel dashboard to evaluate the historical and forecasted performance of a hotel—compared to that of its competitive set105add_shopping_cart$150.00by Hicham Bou Habib
Dot plot / Dumbbell and Lollipop charts in ExcelExcel/PowerPoint template to create Dot Plots, Dumbbell and Lollipop charts to rank one or two data series.106add_shopping_cart
Cycle Plot in ExcelExcel/PowerPoint template to build Cycle Plots, Run Sequence Plots and Graph Envelope Overview to detect seasonality.57add_shopping_cart
One-dimensional Scatterplot with Jitter in ExcelExcel/PowerPoint template to build 1-dimensional scatterplots—with jitter—to show distributions for several categories.90add_shopping_cart
Bar Chart With Color Ranges In ExcelExcel/PowerPoint template to build a bar graph with color ranges of bars representing another dimension in the data.49add_shopping_cart
Arrow Chart in ExcelExcel/PowerPoint template to create Arrow Charts (Range bar graph) to show change between two points in time.53add_shopping_cart
Slopegraph in ExcelExcel/PowerPoint template to create Slopegraph to show change between two points in time.46add_shopping_cart
Small Multiple of Bar Graphs or Line Charts in Excel (Trellis / Coplot)Excel template to build a Small Multiple of Bar Graphs or Line Charts—in one chart—for ease of analysis and formatting.46add_shopping_cart$20.00by Hicham Bou Habib
Non-ribbon Sankey Diagram in ExcelExcel template to create a Non-ribbon Sankey Diagram used to depict connections between one dataset and another.31add_shopping_cart
Any questions on Scatter Plot Matrix In Excel (12x12 Panels) With Correlation Matrix?
The user community and author are here to help. Go ahead!