Create a Histogram in Excel

Your goal

You need to create a histogram of numerical data in Excel.

Step-by-step tutorial

First select your column of data. Here we're using annual precipitation in Central Park :

Annual precipitation in Central Park, 1869-2019
Annual precipitation in Central Park, 1869-2019

Next go to the Insert tab and choose the chart icon in the following figure. You will see choices for histograms and boxplots (also known as box and whisker plots). Choose a histogram:

Choosing a histogram
Choosing a histogram

The resulting histogram should look something like this:

Histogram for annual precipitation in Central Park, 1869-2019
Histogram for annual precipitation in Central Park, 1869-2019