Close this search box.

Basic Histogram Help

The Basic Histogram is a picture of how often a value or range of value occurred in a data set. The histogram can be easily updated with new data. This page shows you how to make a Basic Histogram. The data can be downloaded at this link. This page contains the following:

Data Entry

The data are entered into a worksheet as shown below (using the first part of the data into the example workbook). The data does not have to start in A1. It can be anywhere on the spreadsheet.

Creating a New Basic Histogram

Options for the Basic Histogram

On the input screen for the basic histogram, there is the button labeled “Show Options”. If you select that button, the input screen will show the options for the Basic Histogram. Each option is described below. It is not required to select any of these options.

Descriptive Statistics

If you select this option, you will get the input screen below. This option places on the descriptive statistics for the data into the upper-right hand corner of the histogram.

When “Select/Change Which to Include” is selected and OK is selected, the input screen below is shown. You can select which descriptive statistics to display on the chart using this.

Titles, Rounding, Dates

If you select this option, the following input screen is shown.

Specs, Nominal, Distribution

If you select his option, the following input screen is shown. The default distribution is “None”. The “Select Distribution” frame is not shown unless the “Non-Normal” option is selected.

To select a non-normal distribution, select the down arrow in the box below “Select Distribution”. The available distributions are then listed. Select the one you want to use.

If you select the “Enter Parameters” option, the input screen below is shown. Select “Enter Parameter Estimates” and the available parameters for the selected distribution will be enabled. The four parameters are location, shape, scale and threshold. Not all four parameters are valid for each distribution. The example below shows the parameters available for the three parameter Gamma distribution.

The example shows the results for the three parameter gamma distribution for the conversion data shown above. The parameter estimates are placed in a text box in the bottom right hand side of the chart.

Updating the Basic Histogram with New Data

The Basic Histogram can be easily updated with new data after it has been added to the spreadsheet. Select the “Update Charts” on the Updating/Options panel on the SPC for Excel Ribbon.

Then select the chart you want to update. See Updating Charts for more information.

How SPC for Excel Finds New Data to Update the Basic Histogram

When a chart is updated, the program will search for new data based on the option selected for the data being in columns or rows (see the first input screen above). If the data are in columns, the program starts with the first cell in the existing histogram range and searches down the column to find the last entry before an empty cell. Once an empty cell is found, it is assumed that there is no more data. If the data are in multiple columns, the first column is used. The same process applies if the data are in rows.

Changing the Options for the Basic Histogram

You can change the current options for a histogram (e.g., to add specs or change the type of distribution) by selecting “Options” on the Updating/Options panel on the SPC for Excel Ribbon.

The list of available charts in the workbook will be displayed. Select the chart you want to change options for. The input screen for that chart will be shown and changes can be made. See Updating/Options for more information.

Changing the Number of Classes, Starting Point, or Class Width on the Basic Histogram

After a histogram is made, you may want to change the number of classes (bars), the starting point, or the class width. To do this, follow the instructions above for “Changing the Options for the Basic Histogram”. When you select the chart from the list and select OK, the input screen below will appear. Note that there is a new option: “Classes, Minimum”.

If you select the “Classes, Minimum” option, the following input screen will appear:

The options selected here will remain when the histogram is updated with new data.

Scroll to Top