In this article:

How to Make Table Charts in Google Sheets

May 8, 2024

Unsure which chart type to use? Click here to find the right chart for your data and the ideas that you want to convey.

Table charts can seem peculiar given that spreadsheets can be thought of as a “enhanced table.” However, table charts are still useful and can be used in creating your dashboard. In fact, some data are best displayed in the form of solid numbers, which is the specialty of table charts. Additionally, table charts prevent the data from being accidentally modified by a stray click. 

In this tutorial, we will learn how to make table charts and how to use their various features to improve our data presentation.

How to format the data for a table chart

Unlike other types of charts, the data for the table chart should be formatted as close as possible to how it is supposed to look, content-wise. This means that columns must be clearly labeled with a header row. 

How to make a table chart

Step 1: Select all the data that you want to convert into a table chart, then click Insert in the main toolbar and then click Chart.

Data selected. Insert option selected, Chart option highlighted in the drop-down menu. 

Step 2: On the Chart editor sidebar that will appear on the right side of Google Sheets, click the drop-down menu below the Chart type label. Select Table chart at the end of the options, under the Other label.

Chart editor sidebar, Setup tab, Chart type drop-down box. Table chart highlighted.

Here is the table chart, resized to fit better.

Annual sales table chart

How to revert the table chart to its original rows and columns

Our table chart, however, has the rows and columns flipped:

The source data, highlighted, and the table chart. 

If you want to switch it back to its original form, simply untick the Switch rows/columns checkbox on the Chart editor sidebar:

Switch rows/columns checkbox unticked

The rows and columns are flipped back to its original state:

Table chart following the same rows and columns as that of the source data. 

How to add row numbers to the table chart

Step 1. Click the Customize tab on the Chart editor sidebar.

Chart editor sidebar, Customize tab, Show row numbers checkbox unticked.

Step 2: Tick the Show row numbers checkbox.

Chart editor sidebar, Customize tab, Show row numbers checkbox ticked.

Here is the table chart with row numbers:

Table chart with row numbers in the first column.

How to change the sort column of the table chart

In table charts, a single column serves as the sort column, where you can sort the rows by ascending or descending order. The selected sort column is indicated with an arrow in its header row:

Table chart. The sort arrow in a column encircled.

There are actually two ways of changing the sort column:

Method 1: Click the column header in order to select that column as the sort column.

Method 2: Click the Customize tab in the Chart editor sidebar, then click the drop-down box below the Sort column header to select the column. By default; the rows are arranged in descending value; tick the Ascending checkbox to arrange them into ascending value. 

Chart editor sidebar, Customize tab selected. Sort column drop-down box highlighted.

For our table chart, the initially-chosen sort column is the Independence Drive column, and selecting the Lucasville District column as the sorting column will give us the following table chart:

Table chart, a different column selected as sort column.

How to add pagination for long table charts

As the table charts essentially convert a sheet into a table, one can also convert a long spreadsheet into a table chart. It would be impractical for a table chart to retain the spreadsheet’s original length. Google Sheets’ table charts have a pagination feature precisely to handle long table charts. 

To add pagination to a long table chart, here are the steps:

Step 1. Go to the Customize tab in the Chart editor sidebar, then tick the Pagination checkbox. 

Chart editor, Customize tab, Pagination checkbox unticked.

Step 2: The Page size attribute specifies the number of rows displayed on each page. To change the page size, click the drop-down box below the label. Select the best page size from the given choices. You can also type in a specific number.

Chart editor, Customize tab, Pagination checkbox ticked. Page size drop-down box selected.

Here is the final table chart:

Final table chart. Note the pages below the bottom row. 

Sample sheet

Table Chart Sample Sheet

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->