How to Create a Histogram in Excel for Beginners (Complete+Pictures)

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

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

As we know that Excel is one of the many programs that can help us in making histograms easily. Then, how to make a histogram in Excel? In this article, I will explain in detail how to create a histogram in Excel very easily. Let’s look at the explanation of how to create a histogram in Excel below.

How to Create a Histogram in Excel (Beginner)

Before starting this step to create a histogram in Excel, the important thing that must be prepared in advance is that the Microsoft Excel program must be installed on your computer. Then, the data needed to be converted into a histogram must also be prepared.

Well, in making a histogram using Microsoft Excel, there are also several ways that can be done. The Microsoft Excel program that I use in this tutorial is Excel 2021 (Excel version 2007 and above is fine). Follow the steps below:

1. Open Microsoft Excel on your computer.

2. Next prepare data you first > then block all data which you want to convert 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 histogram icon.

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

4. In Microsoft Excel 2021, histogram ranges or intervals are known as Bins. If you have your own range, you can change it with select bin width > then fill interval value which is desired.

5. You can edit the histogram by adding elements to the chart axes by click on histogram > then select the plus sign icon > then please select element what do you want.

Notes:

• Axes, this element is used to add data descriptions (can be values ​​or other data) on the X (horizontal) and Y (vertical) axes.
• Axis Titles, this element is used to give a title to each X (horizontal) or Y (vertical) axes or axes.
• 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 the lines on the histogram chart.
• Legend, this element is used to add a legend or information related to the data in the histogram.

6. You can also edit the design of your histogram by: click histogram > then select the Design menu > then please select Change Colors to choose color > then select Chart Style to select the style or style of the histogram.

Easy isn’t it how to make a histogram in Excel? Well, to make your histogram more interesting, you can make edits to the histogram that you can try. The Microsoft Excel program already has very useful tools that you can use to enhance the appearance of your histogram.

That’s how to make a histogram in Excel. Hopefully this article is useful for you. Keep visiting Nesabamedia to get interesting and latest information. Good luck!

Introverted woman. Has a personality that enjoys ‘me time’ more, the beach, and the mountains.

Share :