Bar charts

Use a bar chart when you want to compare individual items. For example, compare ticket sales by location, or show a breakdown of employees by job title.

Learn how to add & edit a chart.

Bar chart

How to format your data

  • First column: Enter a label for each row. Labels from the first column show up on the vertical axis.
  • Other columns: For each column, enter numeric data. You can also add a category name (optional). Values show up on the horizontal axis.
  • Rows: Each row represents a different bar in the chart.

Tip: If the chart doesn’t show the data on the axis you want, learn how to switch rows and columns.

Examples

Semester grades
Grades Juniors Seniors
A 14 28
B 26 34
C 35 30
D 30 5
F 20 15

 

Bar chart showing semester grades

Make a copy

Web traffic sources
Source Percent
Organic search 29%
Direct 23%
Referral 20%
Paid search 17%
Social 11%

 

Bar chart showing web traffic sources

Make a copy

Other types of bar charts

Stacked bar chart

Use a stacked bar chart to show part-to-whole relationships and find trends in data over time. For example, show how 4 office locations contributed to total sales.

Learn how to add & edit a chart.

Stacked bar chart

How to format your data

Example

Class size

School Freshman Sophomore Junior Senior
University A 5,425 6,251 3,650 4575
University B 3,550 4,580 4,400 4100
University C 4,800 5,250 3,850 3600

 

Stacked bar chart showing class size

Make a copy

100% stacked bar chart

Use a 100% stacked bar chart when you want to show the relationship between individual items and the whole in a single bar, and the cumulative total isn’t important.

Learn how to add & edit a chart.

100% stacked bar chart

How to format your data

Example

Sales per month

Month North Region South Region
Jan 44% 56%
Feb 42% 58%
Mar 47% 53%
Apr 54% 46%
May 52% 48%
June 57% 43%
July 60% 40%

 

100% stacked bar chart showing sales per month

Make a copy

Customize a bar 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:

Related articles

Was this helpful?
How can we improve it?