Use a histogram when you want to show the distribution of a data set across different buckets or ranges. The height of each bar represents the count of values in each range. For example, show how long customers were on hold with your call center.
Learn how to add & edit a chart.
How to format your data
- First row (Optional): In the first row of the column, enter a category name. Entries in the first row show up as labels in the legend.
- First column: Enter numeric data. You can also add a category name (optional).
- Other columns (Optional): Enter numeric data. You can also add a category name.
Examples
Test scoresTest scores |
62 |
55 |
70 |
75 |
62 |
70 |
89 |
62 |
55 |
89 |
62 |
70 |
70 |
95 |
Weekly salary - Entry level employees |
$800 |
$850 |
$1,000 |
$950 |
$1,200 |
$1,100 |
$800 |
$1,000 |
$950 |
$1,200 |
$1,100 |
$850 |
$1,100 |
Customize a histogram chart
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize.
- Choose an option:
- Chart style: Change how the chart looks.
- Histogram: Show item dividers, or change bucket size or outlier percentile.
- Chart & axis titles: Edit or format title text.
- Series: Change bar colors.
- Legend: Change legend position and text.
- Horizontal axis: Edit or format axis text or set min or max values.
- Vertical axis: Edit or format axis text, set min or max value, or log scale.
- Gridlines: Add and edit gridlines.