Histogram charts

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.

Histogram 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 scores
Test scores
62
55
70
75
62
70
89
62
55
89
62
70
70
95

 

Histogram chart showing test scores

 

Make a copy

Weekly salaries
Weekly salary - Entry level employees
$800
$850
$1,000
$950
$1,200
$1,100
$800
$1,000
$950
$1,200
$1,100
$950
$850
$1,100

 

Histogram chart showing weekly salaries

 

Make a copy

Customize a histogram chart

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. 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.

Related articles

Was this article helpful?
How can we improve it?