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?
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
Search Help Center
true
35
false