How To Prepare Histogram In Excel

As a data analyst, I’ve found histograms to be incredibly useful in visualizing the distribution of data. In this article, I will guide you through the process of creating a histogram in Excel, a handy tool for anyone working with data. So, let’s dive in and learn how to effectively prepare a histogram in Excel.

Step 1: Organize Your Data

Before creating a histogram, it’s crucial to organize your data properly. Make sure your data is in a single column in Excel, and it should be numeric. For example, if you’re working with sales data, you might have a column that includes the sales figures. It’s also important to have a clear understanding of what your data represents.

Step 2: Open Excel and Select Data

After organizing your data, open Excel and input your data into a new worksheet. Once your data is entered, select the range of cells that contain your data.

Step 3: Insert a Histogram

With the data selected, navigate to the “Insert” tab in Excel and locate the “Charts” group. From there, click on the “Insert Statistic Chart” button, then choose “Histogram” from the dropdown menu.

Step 4: Format the Histogram

Once the histogram is inserted, you can further customize it by adjusting the bin width and other formatting options. Right-click on the bars of the histogram and select “Format Data Series” to modify the gap width, colors, and other visual elements.

Step 5: Interpret the Histogram

Now that you have your histogram, it’s time to interpret it. A histogram displays the distribution of your data, showing the frequency of values within certain ranges. It’s a powerful tool for identifying patterns and outliers within your dataset.

Step 6: Adding Data Labels and Titles

To make your histogram more informative, consider adding data labels and chart titles. You can do this by clicking on the chart elements and selecting “Add Chart Element” from the “Design” tab.


Creating a histogram in Excel is a valuable skill for anyone working with data. By following these steps, you can efficiently visualize the distribution of your data and gain valuable insights. So, next time you’re exploring a dataset, consider using a histogram to uncover meaningful patterns and outliers.