Table charts

Use a table chart to turn a spreadsheet table into a chart that can be sorted and paged.

Learn how to add & edit a chart.

How to format your data

Columns: Enter numeric data or text. Data within each column must be the same type.

Tip: To sort the table, click on a column header in the chart.

Examples

Employee salaries
Name Salary Full time employee
Ashley $60,000
Tom $20,000
James $50,000
Michelle $45,000
Susan $55,000
John $15,000
Kathleen $25,000
Darlene $70,000
Max $30,000
Allison $70,000
Sarah $20,000
Rachel $25,000
Table chart showing employee salaries

Make a copy

Annual revenue & net income
Year Revenue Net income
2014 $43,000 $10,500
2015 $56,400 $11,345
2016 $67,988 $12,430
2017 $78,333 $14,000
2018 $94,500 $15,768
Table chart showing revenue and net income

Make a copy

Customize a table 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 and then Table.
  4. Change how the table looks, sort the table, or add pagination.

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