This example illustrates the use of Analytic Solver Data Mining's chart wizard in drawing a Line Chart using the Airpass.xlsx data set. On the Data Mining ribbon, from the Applying Your Model tab, select Help - Examples to open Airpass.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.

Chart Wizard 

Select Line Chart, then click Next to open the Chart Wizard - Variable Selection dialog.

  Variable Selection Dialog 

On the Select Passengers, then click Next to open the Chart Wizard - X Axis Selection dialog.

  X Axis Selection Dialog 

Select Month, and click Finish. To choose Panel and Color options, click Next. Both can be selected or changed in the upper right-hand corner of the plot.

Line Chart 

The  Y axis plots the number of passengers and the X axis plots the month. The plot shows that as the months progress, the number of airline passengers increases.

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 LineChart 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 - LineChart.

Using Analytic Solver Cloud to Create a Line Chart

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

  • Change the x-axis variable by clicking the down arrow next to X-axis.   
  • Filter your results by clicking the down arrow next to Filter.