Skip to Content

How to Make a Table Chart in Google Sheets

Table charts are a useful way to display data that offers some benefits over just entering numbers into your spreadsheet to use as a table.

In this tutorial, I will show you how to create a table chart in Google Sheets.

Table of Contents

Creating a Table Chart

Making a table chart in Google Sheets is a simple process

Here are the steps:

1. Firstly, you need to have the data that will be used to create the table chart in your spreadsheet. If your data is not already in the sheet, enter all of the columns and rows that you want as part of your table

table-chart-1

2. Next, highlight the data that will be used to make the table

table-chart-2

3. In the top menu, select Insert>Chart

table-chart-3

4. You should now see the Chart editor on the right side of your screen. In the Chart editor under the Chart type section, set the chart to Table chart. This option is currently in the “other” section at the bottom

table-chart-4

5. You will now have a table chart in your spreadsheet which you can now customize

table-chart-5

Editing the Table Chart

One of the main benefits of using a table chart in your spreadsheet is that your original table remains intact.

So you can customize and edit your table chart without changing your original data.

Here are a few of the customization options that you have with a table chart.

If you want to remove columns for your table chart you can do that under the Setup tab of the Chart editor by selecting the three-dot menu next to the column and removing it.

edit-table-chart-1

If you want to switch rows and columns or remove headers, you can find those settings near the bottom of the Setup tab in the Chart editor:

edit-table-chart-2

In the Customize tab of the Chart editor you will find settings for:

  • Removing or adding alternating row colors
  • Showing row numbers
  • Sorting your data
  • Adding pages to your table

edit-table-chart-3

Closing Thoughts

Most people just use their spreadsheet as a table and are not aware that this is actually a built-in chart-type option.

These kinds of charts are very easy to set up, and if you want to display sorted data without affecting your original table, then these are a good option to learn to use.

More Google Sheets Tutorials:
How to Create a Pivot Table from Multiple Sheets
How to Sort a Pivot Table