This example illustrates the use of Analytic Solver Data Mining's Chart Wizard in drawing a Scatterplot Matrix using the Iris.xlsx data set. On the Data Mining ribbon, from the Applying Your Model tab, select Help - Examples to open Iris.xlsx. Select a cell within the data set, and on the Data Mining ribbon, from the Data Analysis tab, select Explore - Chart Wizard to open the Chart Wizard dialog.

Select Scatterplot Matrix, and click Next.

Select the Petal_width and Sepal_width variables, and click Finish. The Chart Wizard window opens.

Histograms of the selected variables appear on the diagonal.  To remove a variable from the matrix, unselect the desired variable under Filters.  To add a variable to the matrix, select the desired variable under Filters.

Graphs on either side of the diagonal represent a pairwise relationship between the two variables, petal_width and sepal_width.  The Y-axis for either plot can be found on the far right of the chart and the X-axis for either plot can be found at the bottom. 

Use the Color By feature to group the plotted points by species type.

Please see the section Common Chart Options (below) for a complete description of each icon on the chart title bar.

Common Options ToolBar

To exit the graph, click the red X in the upper right-hand corner of the Chart Wizard Window.

Save Chart Window

To save the chart for later viewing, click Save. To delete the chart, click Discard. To cancel the save and return to the chart, click Cancel. For this example, type ScatterplotMatrix for the chart name, then click Save. To reopen the chart, on the Data Mining ribbon, from the Data Analysis tab, select Explore - Existing Charts - ScatterplotMatrix.

Using Analytic Solver Cloud to Create a Scatterplot Matrix

Click Help – Example Models – Forecasting / Data Mining Models in Analytic Solver Cloud to open the Iris dataset.  Then click Explore – Chart Wizard and select Scatterplot Matrix.

  • Click Filter to add or subtract variables from the plot. 
  • Select Color By to add a specific color to group the plotted points by color.