Guide for performing a Histogram in Excel

  1. Open your data file in Excel.
  2. Highlight the data you want to include in the Histogram.
  3. Clik Data Analysis.
  4. Select Histogram from the data analysis menu.

The range of the cells you selected should be in the INPUT RANGE box. If not, enter the range of the cells that you want to include in the Histogram. Then, click in the OUPUT RANGE box and enter the cell that you want the upper left part of the Histogram to be placed.

  1. Select the "Chart Output" box. (Don't select "Pareto" or "Cumulative Percentage")
  2. Click on OK and a bin table and Histogram (looking like the ones below) should appear on your spreadsheet.

Copyright © 1999 Central Virginia Governor's School for Science and Technology, Lynchburg, VA