how to make a histogram from a frequency table in excel

This should give you a histogram with a frequency polygon. Hence, you can assign a slight Gap Width, like say 3% for a better look. Although a histogram has technically no gap between its bars technically, settting the Gap Width to 0% is not visually appealing. This should bring up a sidebar (or a pop-up, depending on your version of Microsoft Word), wherein you can reduce the Gap Width.To do so, right-click on one of the Series 1 bars, and on the context menu that appears, select Format Data Point.To make our bar-line chart into a histogram, we need to remove the gap between the bars. You should now have a bar graph from Series 1, and a line graph from Series 2, which come together to form a bar and line graph.Īrticle continues after the advertisement: Turning the chart into a histogram.

On the ensuing pop-up, select one of the line graphs, then click OK.

Right-click on one of the Series 2 bars, and on the context menu that appears, select Change Series Chart Type. This should bring up a pop-up similar to the one seen when first creating the bar graph. We will be removing Series 3, and formatting Series 2 so that it displays as a line (instead of a bar). Each horizontal category of your chart should be partitioned into 3 “series”.

A bar chart should appear on your Word document, alongside an accompanying Microsoft Excel window containing the data for the chart.

Select the first chart in the Column tab, then click OK to create the chart.

Bar charts are categorised under the Column tab in this pop-up.

Go to the Insert panel, then click on the Chart icon to open up a pop-up where you can select the chart you want to insert.

We will start by creating a bar chart.

Once that is done, we will modify that so that it resembles a histogram used for visualising frequency distributions. To begin, we will first create a bar-line chart in our Word document. They say a picture speaks a thousand words, so our video probably speaks more than 3000.

How to make a histogram from a frequency table in excel