# Guide on How to Make a Histogram in Excel, It's Easy!

Geekers - Microsoft Excel is one of the most popular number processing software made by Microsoft company. Although known as a number processing program, Microsoft Excel is also often used to process other data. One of them is in the field of statistics, namely the histogram. The use of a histogram will really help us to see a summary in a data. With its appearance in the form of a bar graph, of course, it will make it easier for us to analyze a problem in the data.

The patterns that are built according to the distribution of a data in this histogram can be used to draw conclusions. Thus, the presentation of data equipped with a histogram will be very beneficial for various parties.

As we know that Excel is one of the many programs that can help us make histograms easily. Then, how do you make a histogram in Excel? In this article, I will thoroughly discuss how to make a histogram in Excel very easily. Let's see the following explanation on how to make a histogram in Excel.

How to Make a Histogram in Excel (Beginner)

Before starting the steps to create a histogram in Excel, it's important to be prepared first, namely that the Microsoft Excel program must already be installed on your computer. Then, the data needed to be converted into a histogram must also be prepared.

So, in making a histogram using Microsoft Excel, there are also several ways you can do it. The Microsoft Excel program that I use in this tutorial is Excel 2016 (Excel version 2007 and above doesn't matter). Follow the steps below:

1. Open Microsoft Excel on your computer.

2. Then prepare your data first > then block all the data you want to make into a histogram > then select the Insert menu > then select the insert chat statistics icon or look at the icon marked with a red box > then select the histogram icon.

How to Make a Histogram in Excel How to Make a Histogram in Excel

3. Then the histogram will appear. Now the Microsoft Excel 2016 program will automatically determine the range or interval of data. To determine the range or value of the upper and lower limits, please right-click on the Axes Value area and select Format Axis.

step 3 - select the axis format step 3 - select the axis format

4. In Microsoft Excel 2016, the histogram range or interval is known as Bins. If you have your own range, you can change it by selecting Bin width > then filling in the desired interval value.

How to Make a Histogram in Excel How to Make a Histogram in Excel

5. You can edit the histogram by adding elements to the chart axis by clicking on the histogram > then selecting the plus sign icon > then please select the element you want.

How to Make a Histogram in Excel How to Make a Histogram in Excel

Notes:

* Axes, this element is used to add data information (can be values or other data) on the X (horizontal) or Y (vertical) axis.

* Axis Titles, this element is used to give titles to each axes or axis X (horizontal) and Y (vertical).

* Chart Title, this element is used to give the title of a histogram.

* Data Labels, this element is used to display data labels or the number of frequencies at each interval value.

* Gridlines, this element is used to display lines on the histogram diagram.

* Legend, this element is used to add a legend or description related to data on the histogram.

6. You can also edit the design of your histogram by clicking the histogram > then selecting the Design menu > then please selecting Change Colors to select a color > then selecting Chart Style to select a style or style from the histogram.

How to Make a Histogram in Excel How to Make a Histogram in Excel

Isn't it easy to make a histogram in Excel? Well, to make your histogram more attractive, you can make edits to the histogram that you can try. The Microsoft Excel program already has very useful tools that can be used to enhance the appearance of your histogram.