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.
Select Line Chart, then click Next to open the Chart Wizard - Variable Selection dialog.
On the Select Passengers, then click Next to open the Chart Wizard - 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.
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.
To exit the graph, click the red X in the upper right-hand corner of the Chart Wizard 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.