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 | ✗ |
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 |
Customize a table chart
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize Table.
- Change how the table looks, sort the table, or add pagination.