logo

How to Draw a Histogram in Excel 📂Programing

How to Draw a Histogram in Excel

Overview

This introduces how to draw a histogram through Excel.

Description

Slide1.PNG

Click on the [File] tab, then click on [Options] below to bring up the [Excel Options] window. In [Add-Ins], press [Go] at [Analysis ToolPak] and then press [OK].

Slide2.PNG

Now you can confirm that the [Data Analysis] item has been added to the [Data] tab. Press it and select [Histogram].

Slide3.PNG

Choose the range of values and the intervals of the bins, check [Chart Output], and press OK.

Slide4.PNG

Then, you will get a histogram of the heights data for the Queendom 2 cast.