1

I have a column of grades on a Google Sheets document and I want to generate something like that:

enter image description here

I only managed to create a simple histogram with custom bucket size, but I want it to be more informative and show the distribution of the grades in each bucket. Is that possible? If so, how?

I also tried the Stacked chart type, but haven't succeed in doing what I'm looking for.

5
  • The "histogram with inner divisions" looks like a stacked bar chart. Have you tried to create one? Commented Jul 19, 2018 at 15:02
  • I actually did, but it didn't looked like I expected, maybe I missed some configurations of it? Commented Jul 19, 2018 at 15:06
  • I walked through everything in the customize tab, but no luck. Maybe I need to arrange my data in a different way? Commented Jul 19, 2018 at 15:29
  • Downvoter - explain? Commented Jul 27, 2018 at 9:16
  • This explanation may help - statology.org/google-sheets-stacked-bar-chart
    – yoyo
    Commented Apr 20, 2022 at 18:30

1 Answer 1

3

If you have a list of grades in the form of raw data, to use a stacked bar chart to make an histogram first you should create a table of frequency distributions. Since you want to show "inner divisions" you should include a column for each "division".

The shape of the table of frequency distribution with inner divisions should look like the following

        +0   +1   +2    +3    +4
50-54
55-59
...

If you don't wan't to do this by yourself then you could look if there is a Google Sheets add-on for statistics similar to Statistics (AFAIK it hasn't an histogram with "inner divisions")

Related Google Sheets Functions

Related Q&A

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.