How to build a histogram in Excel


The ideal solution for visualizing data in theThe table will undoubtedly have a histogram. The type of such a chart is able to the ordinary user to convey the basic essence of all the values ​​without even getting acquainted with them.

The article will analyze the histogram in Excel. How to do it, you will find out when you have finished reading the article. In addition, all the nuances that arise during the construction process will be considered. Also you will get acquainted with four different options, available to show how the histogram is built in Excel.

The options for building a histogram in Excel

The most popular table editor offers the following options for building a histogram:

  • simple histogram;
  • histogram with accumulation;
  • using the analysis package;
  • with conditional formatting of cells.

histogram in excel

Immediately it is worth noting that all of the abovevariants can be executed by a separate object in the table or be a part of it. Well, now let's get down to the analysis of how the histogram is built in Excel.

Method 1: A simple histogram

A simple histogram in Excel is more commonly used. Its construction does not take much time, and the process does not require a deep knowledge of the program.

Initially, it is necessary to select in the table thoseData that will be used in the future in the chart. After that, go to the "Insert" tab and click on the "Diagrams" button. A submenu opens with all available chart types. In our case, click on the "Histogram" tab and select its type in the drop-down menu. It is worth noting that in each row, simple histograms are the first, after which histograms with accumulation are already located.

So, as soon as you click on the diagram you like, the graph of the program will directly display the graph with the data previously located in the selected area.

Before you built a histogram in Excel. How to make an inscription in it, you will learn a little later. For now, it's worth to say that adjustments can be made using tools that are in the group of tabs "Working with diagrams".

Method 2: Stacked histogram

Now a method will be disassembled, showing how the accumulative histogram is built in Excel. You can see an example in this article.

In fact, its creation is no different fromsimple method, but there is one nuance that should be highlighted. Before you start working with the histogram, you need to delete the name of the first column, if any, otherwise it will not work.

Now you can start creating. Just like in the previous method, you need to select a part of the table with the data that will be used for the construction. After that, go to the "Insert" tab, on the toolbar in the drop-down menu "Diagrams", point to "Histograms" and select the cumulative type. It is worth recalling that in each row it is located on the right side.

After clicking on one of the elements on the sheet, a corresponding accumulative histogram will appear in Excel.

histogram in excel how to draw

As last time, you can add to the schedulesome changes with the help of tools in the group of tabs "Working with diagrams". By the way, in both cases, to change the inscription in the graph, you just need to double-click on it and specify a new name.

Method 3: Using the analysis package

From more trivial methods we pass to those that are more complicated. Very few people know that with the help of add-ins programs it is possible to make a histogram, however it can be done.

The first step is to enter the superstructures themselves. To do this, click on the "File" tab and on the sidebar select "Options". Then go to the "Add-ons" category.

Pay attention to the drop-down list"Control". In it, you need to select "Excel Add-ins" and click the "Go" button. The Add-ons window appears. Put a tick in the box next to the "Analysis package" and click "OK."

Now go back to your table, select the data area and go to the "Data" tab. In this tab you need to click on the "Data Analysis" button, which is located in the "Analysis" area.

In the window that appears, select"Histogram" and click "OK" - a window will appear in which you need to set the parameters. In the "Input interval" field, the area of ​​the data table must be specified. If you previously selected it, the value will be automatically entered. Next, check the box next to "Output graph" and just above, specify where to draw this graph. Click "OK" button.

histogram in excel how to make an inscription

Method 4: Conditional formatting of cells

In order to compile a histogram by thisway, you need to select the area with the data and in the "Home" tab, click on the "Conditional Formatting" button. In the drop-down list, move the cursor to the "Histograms" item and choose one of the favorite chart types from the menu.

histogram in excel example

After that, the formatted cells are filled with a scale - this is the histogram. As it is easy to guess, the scale displays the quantitative weight of the data that is in it.


These were four ways by whichcreate a histogram in Excel. All of them are good in their own way and fit for different needs, so check out each one in more detail and select the required one.

Comments (0)
Add a comment