Simple excel bar graph question

Factual Questions
1

I have a list of exam grades ranging from 1.00 to 15.00. How can I make a bar graph showing that x students were graded 1.00 to 1.99, y students were graded 2 to 2.99 and so on?

2

Several ways - the way I’d use is:

  1. over to the right of the data (skip a few columns) - make a column starting in row 2 that has numbers 1:15. Row 1 can then later have title for that column of data.
  2. Use the FLOOR function to turn each number into a round number. I would just use the column next to your column of data for ease.
  3. Use COUNTIF function next to numbers in step one above to count the number of times each score occurs.

You could do it all in less than three steps, but if you don’t understand each one - breaking it down as above might be useful.

3

The type of chart you’re describing is called a histogram. Here’s Microsoft’s page on how to make a histogram in Excel. The procedure varies slightly from version to version.

4

Simply put:

  1. Install the Data Analysis ToolPak (free, nothing to download). You only have to do this once for each computer/install of Excel.
  2. Use the range of values and a bin range to create a table of binned frequencies using the installed tool.
  3. Create a bar graph with those values (in Excel, the one you want is called “Column” not “Bar”.
    3b) Histograms normally have no space between the bars, so decrease that distance.

The tricky part is creating the bin values. The Histogram tool does not create formulas, so you have to run it each time you change any data. You can have it overwrite the old output.