The only chart you can turn into a Histogram is a Column or a Bar Chart to do this right-click the Column Chart and select the Format Data series, a Format data series pane will appear on the right. Now where you see Gap Width carry it down to 1%.  Then right-click the Column chart and select Edit data. When the Excel sheet pops up remove the two of the series column and only leave one. Now we have a histogram.