How to Make a Histogram Graph in Excel



Histograms are charts used to present data in an organized graphical format. They are often used to show categories, their frequency distribution and the total number of observations within each category. Histograms are a great way to illustrate how data is distributed across a range of values, and can help highlight specific relationships between values.

Microsoft Excel makes it easy to create a histogram graph with just a few clicks. In this guide, we will explain step by step how to make a histogram graph using Excel:

Setting up Your Data

One of the first steps in making a histogram graph in Excel is to set up your data. You need to format your data in a way that Excel can understand and then create the necessary charts and graphs.

To begin, you’ll have to have your data in a column or row in a spreadsheet. Then, you’ll have to determine the ranges and groups of values you’d like to include in the graph. After that, you’ll need to sort your data and adjust the intervals accordingly.

Let’s look at what else you’ll need to do to get your histogram ready:

Prepare your data

Before you begin to create your histogram in Excel, you will need to prepare the data for graphing. A histogram is a bar graph that displays the values of a set of data according to the frequency of occurrence. This means that you will need to have data arranged according to consistent intervals in order for it to be graphed correctly.

Begin by entering the data into separate cells in an Excel spreadsheet column. The first step is transitioning your data into a format compatible with Excel graphs and charts, which means adjusting interval range so that each value falls within a specified bin (an interval or range of numbers). To do this, open Excel and select the cell range containing your data; this includes every row that contains relevant information as well as any blank rows beneath used for formatting purposes.

Next, click on “Format as Table” from the Home tab at the top of the window and choose an appropriate table style format. This will provide easy recognition when setting up bins later in this process. Once these steps are completed, it is time to create bins from which your graph can be generated. To set up bins, select any cell under the title row and click “Bin” from Data Analysis drop down menu that appears under “Analysis Tools” header on Data ribbon tab at upper left-hand side of window (in some versions of Excel Bin selection may appear from top ribbon). Proceeding with bin setup requires inputting further parameters such as interval width size and number of intervals for given set of data before clicking OK button at bottom right side of menu dialogue box.

Enter your data into Excel

Before beginning to make your histogram in Excel, you need to enter your data into the spreadsheet. Data can be entered manually or imported from a data file, such as a comma-separated values (CSV) or text file. Manually-entered data should be entered into separate columns; this will help you when you are setting up your data for making the histogram.

If you’re manually entering the data, it is important that you label each column appropriately; for example, if your dataset contains speed measurements of cars passing by, label it something like “Speed.” Column headers should always be in the first row of the dataset. Before moving onto graph creation, review your dataset to ensure accuracy and appropriate labeling of columns and variables. In this case, if multiple cars were observed at different speeds in a timed period it may be more appropriate to list “Time Interval” and “Car Measurement” rather than just one unnamed column of notations. Taking the time to plan out and format an organized database allows for better manipulation during later stages of calculations and visualizations.

Creating a Histogram Graph

Creating a histogram graph in Excel can be a useful way to visualize and analyze data. Histograms are a great way to look at the distribution of data, and Excel allows you to quickly and easily put together a histogram graph with just a few clicks.

In this article, we’ll take a look at how to create a histogram graph in Excel, as well as how to interpret the results.

Select your data

Once you open an Excel spreadsheet, it’s important to make sure that the correct data is entered. Histograms are used to display sets of data in a graphical format. To create a histogram in Excel, you need a set of numerical values that describe the data you want to plot.

When selecting your data, be sure to use the same unit of measurement for the values so that they can be accurately compared in your histogram. For example, if you are creating a histogram with temperature readings over a year long period, all temperatures should be displayed in Fahrenheit or Celsius and not both. If standardizing temperature units is not necessary or relevant, then it’s important to make sure that your data is organized clearly and correctly entered into columns on your worksheet before moving on to creating the histogram graph itself.

Insert a histogram chart

A histogram is a type of graph that is used to compare the frequency of different groups or categories of data. It provides a visual representation of the frequency distribution in a dataset, helping you to easily identify patterns and trends.

To create a histogram chart using Microsoft Excel, simply follow these steps:

  1. Create your data. Create a table with one row for each category and one column for each piece of data that needs to be graphed.
  2. Select your range. Highlight the entire table by clicking and dragging your mouse over the data cells; this range will be used to create the chart.
  3. Insert the chart. Go to the “Insert” menu, select “Charts” and choose “Histogram”.
  4. Configure the chart settings according to your preference, such as color, font type and size, axis titles, etc., then click “OK”.
  5. Export or print out your created graph as desired — either save it as an image file or print it directly onto paper/canvas (e.g., by using a printer).

Adjust the chart’s formatting

Once you have input all of your data points and determined how to sort them, one of the next steps in creating a histogram graph is to adjust the chart’s formatting. This includes changing the axis labels, define bars’ width and inter-valley space, split or combine groups’ bars, and many other actions.

The x-axis should be labeled with the bins or classes of data points. The y-axis should be labeled with either a frequency or some other measure that corresponds with data points. The number of bins chosen will determine how much granularity or accuracy there is in displaying the data on the histogram. Additionally, it is important for these categories to be evenly spaced on the chart for easy visualization and comparison.

When it comes to formatting the bars, whether they are vertical columns representing frequency or variable ranges representing classes of information – like size, age range, income range – it is important to assign equal amounts of width and spacing between each one. Also consider using different colors when more than one type of class/category needs to be indicated in order to keep it visually stimulating as well as easier to read/interpret. Additional formatting changes include combining two overlapping classes together and splitting one larger class into two smaller ones for more accuracy; as well as changing font sizes and adding labels if desired. Making sure that layouts are clean but flexible will ensure that readers can easily comprehend what information is being communicated by the chart’s design rather than spending an excessive amount time focusing on its format.


Creating histograms in Excel is a straightforward process that requires you to use the native histogram feature or other data analysis methods. No matter what method you use, there are a few important steps to keep in mind when creating histograms in Excel.

  • First, make sure your data is organized and formatted properly.
  • Then, adjust the various graph options to customize the appearance of your histogram.
  • Finally, double-check that your results make sense before publishing them.

By understanding how to make a histogram graph in Excel, you can quickly and accurately present data as part of any report or analysis. With what you now know, you can explore different types of graphs making it possible to accurately illustrate any piece of data or set of data. With practice and experimentation, your graphs will be the perfect visual representation for any report!