Zend certified PHP/Magento developer

How to create Excel histogram from frequency table?

I have an Excel table with two rows.

One header row with positive integers representing different event properties and another row with the frequency of events with said property number.

Here’s a snippet of said table (ignore the second column):

Table Snippet

I want to create a histogram where the top row is aggregated into different bins and then have each bin’s corresponding frequency. For example, bin [0,5] would have the frequency 1+75+1284+1943+1632+377 = 5312.

How would I go about achieving this?