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

Was this helpful?
How can we improve it?