How to Plot Cumulative Histogram in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

A histogram is one kind of graph which we use to show frequency distribution within some prespecified ranges. These data ranges are called ‘bins’. The histogram chart shows how many data points belong to each of these bins. This article will illustrate how to plot a histogram using cumulative data in Excel with easy steps and proper illustrations.

How to Plot Cumulative Histogram in Excel: Step-by-Step Procedures

1st Step: Collect Data

The very first step is- to collect your data and gather them in an Excel spreadsheet.

sample data create histogram

  • Here we have collected 55 students’ grade points data (CGPA).

2nd Step: Find Maximum and Minimum Values in the Data

  • Here, we have found the maximum and minimum values (2.00 and 4.00)

3rd Step: Add a New Column for Bins

The 3rd step is creating suitable bins. This is up to you. You can create bins with any width.

  • Here, we have specified 0.25 as the width.
  • You can use the following common formula and drag it down until you reach the maximum value 4.00.
  • Here, we have first input the minimum value in cell E5 and then used the following formula.
  • The output will be as follows.


This is an iterative formula. Iterative formulas cause circular reference issues. To make this type of formula work, press ALT+F+T and go to the Formulas section, there, mark the “Enable iterative calculation” box and press OK.

enabling iterative formula

4th Step: Employ FREQUENCY Function of Excel to Get the Frequencies That Belong to Each Bin

The FREQUENCY function returns the number of occurrences of a value within a bin_range. It returns one more element than the specified bins_array, in our case, we will delete that.

  • The common formula is:
FREQUENCY(data_array, bins_aray)
  • Write the following formula in cell F5.

Here, D5:D13 is the data_array and E5:E13 is the bins_array which stands for the range of values.

applying FREQUENCY function

  • Now, copy the cells F5:F14 and paste the values only, in the same place F5:F14.

  • Now, delete the last 0.

5th Step: Calculate Cumulative Frequency

  • Now, add a new column named Cum. Frequency and apply the following formula in cell G5.
  • The common formula is:
  • Now, drag the fill handle icon to copy the formula downside.

calculating cumulative frequencies to create a histogram

Last Step: Plot Cumulative Histogram from Recommended Charts

  • Now, select the whole range that contains Bins, Frequency, and Cum. Frequency columns, E4:G13.

select data to create a cumulative histogram

  • Then go to the Insert tab.
  • From the Charts group, click on the tiny Recommended Charts icon.

  • From the Insert Chart window, select the 2nd chart type and press OK.

Here the procedure ends. Look at the following image, we have drawn the cumulative histogram successfully.

Cumulative histogram in Excel

Read More: How to Create Probability Histogram in Excel

Download Practice Workbook


I hope this brief discussion will help in plotting a cumulative histogram in Excel. If you have any queries, please let us know in the comment box. Visit us and enjoy Excelling!

Related Articles

<< Go Back to Excel Histogram | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Masum Mahdy
Masum Mahdy

Abu Talha Masum Mahdy (Assistant Project Manager, ExcelDemy) has been working with the ExcelDemy family for over 2 years. He wrote 30+ articles and reviewed more than 1300 others for ExcelDemy. Currently, he is responsible for reviewing articles from 2 writing teams of ExcelDemy. He ensures correctness and fluency in his team write-ups. Mahdy holds a BSc in Naval Architecture and Marine Engineering from BUET. His interests are Project Management, Content Writing, SEO, Digital Marketing, Data Analytics and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF