The example below illustrates the use of Analytic Solver Data Mining’s chart wizard in drawing a histogram of the Utilities.xlsx dataset. 

Click Help – Examples on the Data Mining ribbon to open the example dataset, Utilities.xlsx.  Select a cell within the dataset, say A2, and then click Explore – Chart Wizard on the Data Mining ribbon.  The following dialog appears.


Select Histogram, and click Next. The Chart Wizard - Y Axis Selection dialog opens.

Select Frequency, and click Next. The Chart Wizard - X Axis Selection dialog opens.


Select X1, and click Finish.

The data has been divided into 10 different bins or intervals.  To increase or decrease the number of bins in the histogram, move the Bins slider to the right or left, respectively. 

To change the variable included in the plot, simply click the Histogram icon on the title bar of the Chart Wizard, tro bring up the X-Y Axis selection dialog. 

 Chart Wizard Tool Bar

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 Dialog 

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 Histogram for the chart name, then click Save.  The chart will close.  To reopen the chart, click Explore – Existing Charts – Histogram.

Using Analytic Solver Cloud to Create a Histogram

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

  • Change the plotted variable by clicking the down arrow beneath Selected Variable.