How to make a "interval" bar chart

Your sample file does not include your attempt at creating a chart, so it is difficult for us to know exactly what is happening.

I notice that the current selection is F1:F4. I also notice that each cell in that range is currently text (xxx-yyy is not a range of numbers to Excel but a text string).If I take the current selection (F1:F4). If I insert a pie chart based on the current selection (of all text strings), Excel "guesses" as best it can (based on an algorithm that I don't understand) what you intend to do with that range. After creating the chart, I can open up the "select data" dialog and see that Excel is choosing to assign F1:F3 as the "series name" part of the series definition, it is assigning F4 as the "values" part of the series definition, and assigning nothing to the series categories (so it is defaulting to the number 1). With only one data series in the chart, Excel decided that it should make the chart title the same as the series name (the text in F1:F3).

That is what Excel did. I don't understand why Excel did what it did.

Fixing this is usually about pulling up the select data dialog and telling Excel what you want to use for each part of the chart. Then you will need to enter real numbers (not number ranges as text strings) so Excel will know what value to assign to each slice of the pie (or each column of a column chart or each bar of a bar chart or...). Charts tend to assume text strings have the value 0.

From there I am not sure exactly what you are trying to do. The generic solution that I see is to assign the correct ranges to the desired chart elements and then give the chart some real numbers to work with.

Assuming I understand, you need to recognize that charts are based on the actual data you tell them to chart. If you want a chart of summary data (in this case, counts of the data), you need to generate the summary data in the spreadsheet before creating the chart. In this case, you can use a pivot table (http://www.excel-easy.com/data-analy...ot-tables.html )or a COUNTIFS() function (https://support.office.com/en-us/art...c-aa8c2a866842 ) or a FREQUENCY() function (https://support.office.com/en-us/art...7-fd9ea898fdb9 ) to generate the summary data, then base the chart on the summary data. Using a FREQUENCY() function:
1) Enter the "bins" data (the boundary values between your weight divisions) into a column of cells (...901, 1001, 1251, 1499,...).
2) Enter a FREQUENCY() function in the column adjacent to it (remember that the FREQUENCY() function is an array function so it must be confirmed with ctrl-shift-enter).
3) Create pie chart from the results of the FREQUENCY() function.
Is that close to what you want?