We did a survey at work recently. It had 72 ten-point-scale responses and I needed a quick way of seeing the distribution of people’s scores.

Inspired by spark tweets I made a little Google spreadsheet function (embedded Gist below) that makes cells that contain this kind of thing:

▁░░░▃░▁▅▁█
█▄▁▁▂▃▇▆▂░
▁▄▁▃▃▂▂█▂░
█░░░░░░░░░
█░▃▂█▁▅▁░▁
█▁▂░▁░░░░░
▂░░░░▄▆█▅░
█░▁░░▁▁░░░
█▁▂▁▁░▁▁░░
█░░░░░░░░░
█░░░░░░░░░
█▂▂▁▁░▁░░░
█░░░░░░░░░
▄░▁▁▃░█▅▁▁
▆▂▁░▃▁▄▇█▁
█▁░░▁░▂▁░░
█▅▄▆▁▂▅░▁▁
▇▆█▅▅▃▄▅▂░
█░░░░░░░░░
▂█▃▂▂▂▄█▂

It’s pretty limited in that it only handles numbers between 1 and 10, and has fixed bin widths of 1, but it get the job done for my needs. If you are interested in using it and don’t know how to put it into your spreadsheet or want it to do something else then just let me know in the comments.