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
$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

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
2183294958096157096
true
Search Help Center
true
true
true
true
true
35
false
false