Posts

Showing posts with the label histogram chart

Google Sheets - Histogram chart

Image
In this tutorial we will create a histogram like below. Histogram is commonly used in statistics to show data distribution. Suppose you go fishing today and today is your lucky day. You got 10 fishes! You measured length of each and get a data like below: 1. Click Insert > Charts. Google Sheets automatically generate a histogram chart for you. Very smart. 2. There is no vertical axis label, which may be hard to read for your audience, so we want to add a vertical axis title. Right click the chart, select Chart & axis titles, then Vertical axis title. 3. Fill "Number of fishes" in the Title text field.  4. Now the vertical axis title is added. The chart reads this way: there are 2 fishes whose length is between 13.0 and 14.1 cm, 3 fishes whose length is between 14.1 and 15.2 cm, etc.