Answered By: Berkeley College Library
Last Updated: May 06, 2020     Views: 193

1). Highlight the cells with numerical data that you want to be included in the chart and go to Insert > Recommended Charts.

2). Select All Charts > Histogram > OK.

3). Now you have your Histogram Chart.

For a visual of these steps to create a Histogram in Excel, see below.


1. Highlight the cells with numerical data that you want to be included in the chart and go to Insert > Recommended Charts.

screenshot of an Excel spreadsheet showing Insert Ribbon

2. Select All Charts > Histogram > OK.

screenshot of Excel Insert Chart dialog box

3. Your histogram chart will appear directly on your Excel spreadsheet. Use the screenshot of Excel plus sign and screenshot of Excel paintbrush icon buttons to edit chart elements and design.

screenshot of Excel histogram chart

Related FAQs