First, make a decision as to how many columns to average.

First, re-draw the chart as a 1X1 chart,

First, find the longest column, and count the number of filled boxes.

First, convert the chart to a conventional line chart.