How To Make A Histogram Excel

Productivity Software

Making a histogram in Excel is a handy skill to have, especially for anyone working with data analysis or visualization. As a data enthusiast, I find histograms to be an effective way of showcasing the distribution of data. In this article, I will guide you through the steps of creating a histogram in Excel, along with some personal insights that I’ve discovered along the way.

Getting Started

To begin, open Microsoft Excel and prepare your data. For this example, let’s say we want to create a histogram for a set of exam scores. Once you have your data ready, select the cells containing the data you want to include in the histogram.

Inserting the Histogram

Next, navigate to the “Insert” tab in Excel, and then click on “Insert Statistic Chart”. From the dropdown menu, select “Histogram”. This will create a basic histogram using Excel’s default settings. The histogram will be displayed on your worksheet, and a new window will appear on the right side of the Excel window, displaying the chart-specific options.

Customizing the Histogram

Now, it’s time to customize the histogram to better fit your needs. You can modify the bin size, axis labels, titles, and more by using the options available in the right-hand pane. This is where you can add your personal touch to the chart, making it visually appealing and informative.

Interpreting the Data

Once the histogram is set up, take some time to interpret the data it presents. Histograms provide a visual representation of the distribution of your data, allowing you to identify patterns and outliers. Pay attention to the shape of the bars and the overall trend that the histogram displays.


Creating a histogram in Excel is a valuable skill for anyone working with data. It allows for a clear and concise visualization of data distribution. By following the steps outlined in this article, along with adding your personal touch to the chart, you can effectively communicate your data’s distribution in a visually appealing manner.