How to Customize Tables in Google Data Studio [Complete Guide]

How to Customize Tables in Google Data Studio 43
Key Takeaways: How to Customize Tables in Google Data Studio

To Customize Tables in Google Data Studio

  1. Access the Style Tab.
  2. Customize Table Headers and Colors.
  3. Customize Table Labels and Body.
  4. Customize Table Footer and Handle Missing Data.
  5. Customize Dimensions, Alignment, Axis, and Target.
  6. Modify Background and Border Colors.

So finally, after creating and working with so many charts in Google Data Studio, today we are going to learn how to customize tables in Google Data Studio. So, this article will only focus on styling and customization of charts, we will see various charts and will explore so many customization features of Data Studio. In google sheets, we learned and worked on so many charts, since Data Studio is primarily about charts so we will see detailed customizations, there are some distinct options in Data Studio as compared to sheets, we will explore those features and try to customize our charts beautifully based on themes colors, etc.

Why Use Tables in Google Data Studio?

Since we have already seen the creation and calculation of charts, this is the right time to learn about customization. Because colors, themes, fonts, and styling are the main courses going to attract our users/viewers, or customers. So it’s very important to learn and use excellent customization and styling features of Data Studio. We can have full control over the styling and customization of our charts, so therefore we need to learn how to customize tables in Google Data Studio.

How to Customize Tables in Google Data Studio?

To not skip any of the vital features in the style tab of our charts in Data Studio, we will start from the top and go to the bottom, we will see each and every section and will apply them to our charts to make them appealing, attractive, and user friendly. Let’s start.

So, I am starting from the style tab of a chart, before this you need to have a simple chart on your canvas, select the chart and go to the style tab.

How to Customize Tables in Google Data Studio 1

Customize Tables in Google Data Studio – Table Header and Colors

This is the very first section of the style tab in Data Studio charts just after conditional formatting (Conditional formatting is a big topic, so we will cover it in other tutorials). Let’s see what we have got in the header section

Step 1

Show header checkbox

How to Customize Tables in Google Data Studio 2

How to Customize Tables in Google Data Studio 3

It’s checked by default; we can uncheck it to hide the table headers

Step 2

Wrap text.

How to Customize Tables in Google Data Studio 4

How to Customize Tables in Google Data Studio 5

This option is understandably only found when table headers are shown, using this checkbox we can wrap the text of our headers, the same wrap text as we have in Google Sheets.

Step 3

Header font color
This option is also only available when headers are shown, here we can set the font color for headers

How to Customize Tables in Google Data Studio 6

Step 4

Header font size (change the font size of header text)

How to Customize Tables in Google Data Studio 7

Step 5

Header font family (change the font family for header text)

How to Customize Tables in Google Data Studio 8

How to Customize Tables in Google Data Studio 9

How to Customize Tables in Google Data Studio 10

Step 6

Table colors

Header background color (background color only for header)

How to Customize Tables in Google Data Studio 11

Cell border color (cell outline color)

How to Customize Tables in Google Data Studio 12

Odd row color (background fill color for every odd row such as 1,3,5,7 and so on)

How to Customize Tables in Google Data Studio 13

Even row color (background fill color for every even row such as 2,4,6,8 and so on)

How to Customize Tables in Google Data Studio 14

Customize Tables in Google Data Studio – Table Labels and Body

In this section, we will learn how to customize tables in Google Data Studio and will check out table labels and body sections, as the name suggests here, we have got some labeling options and some customization for table bodies. Let’s see the detailed features.

Step 1

Font Color (change the table text font color)

How to Customize Tables in Google Data Studio 15

Font size (change the table text font size)

How to Customize Tables in Google Data Studio 16

How to Customize Tables in Google Data Studio 17

Font Family (select a font family for table text content)

How to Customize Tables in Google Data Studio 18

How to Customize Tables in Google Data Studio 19

Step 2

Row number checkbox (show hide row numbers)

How to Customize Tables in Google Data Studio 20

Wrap text checkbox (wrap or unwrap text)

How to Customize Tables in Google Data Studio 21

Horizontal scrolling checkbox (enable or disable horizontal scroll bar)

How to Customize Tables in Google Data Studio 22

Customize Tables in Google Data Studio – Table Footer and Missing Data

In this section, we will learn how to customize tables in Google Data studio regarding the footer area, we have some elements in the footer, and we can surely customize them as we have full control of every element of our chart. Let’s see what option we have got here.

Step 1

Show pagination checkbox (This will show the pagination, which means current page and total pages)

How to Customize Tables in Google Data Studio 23

Step 2

Compact pagination (a little packed view of pagination)

How to Customize Tables in Google Data Studio 24

Step 3

Footer border-color

How to Customize Tables in Google Data Studio 25

Step 4

Footer border weight

How to Customize Tables in Google Data Studio 26

Step 5

Footer border style

How to Customize Tables in Google Data Studio 27

How to Customize Tables in Google Data Studio 28

How to Customize Tables in Google Data Studio 29

How to Customize Tables in Google Data Studio 30

Step 6

Missing data

Here, we can select what to show when data is missing, we have so many options like null, no data, etc.

How to Customize Tables in Google Data Studio 31

How to Customize Tables in Google Data Studio 32

Customize Tables in Google Data Studio – Dimensions, Alignment, Axis, Target & More

In this section, we will learn how to customize tables in Google Data Studio, we will see alignments for dimensions, and metrics. Let’s check out what options we have

Step 1

Alignment for dimension (we can set alignment for dimension text as left, right, or center)

How to Customize Tables in Google Data Studio 33

How to Customize Tables in Google Data Studio 34

How to Customize Tables in Google Data Studio 35

How to Customize Tables in Google Data Studio 36

Step 2

Alignment for metrics (Here we can select do the same with metric content)

How to Customize Tables in Google Data Studio 37

How to Customize Tables in Google Data Studio 38

How to Customize Tables in Google Data Studio 39

Step 3

We have another option here, we show Numbers, Heatmap, or Bar/Pub for the values of the metric
How to Customize Tables in Google Data Studio 40

Numbers are by default (show values)

How to Customize Tables in Google Data Studio 41

Heatmap (shows a heatmap with values and fill colors), we can also change color

How to Customize Tables in Google Data Studio 42

How to Customize Tables in Google Data Studio 43

Bar/Pub (shows a bar chart instead of numbers), we can also change the color of the bars, and we can also enable numbers with bars from the below checkbox “Numbers”

How to Customize Tables in Google Data Studio 44

How to Customize Tables in Google Data Studio 45

How to Customize Tables in Google Data Studio 46

Step 4

Compact numbers checkbox (it will show packed numbers such as 1K for 1000)
How to Customize Tables in Google Data Studio 47

Step 5

Decimal precision, here we can select the trailing decimal points from 0-3 or auto

How to Customize Tables in Google Data Studio 48

How to Customize Tables in Google Data Studio 49

Step 6

Show target checkbox (we can show or hide the target line, we can also set the target value for it)

How to Customize Tables in Google Data Studio 50

Below we can also select the target color

How to Customize Tables in Google Data Studio 51

Step 7

Show Axis checkbox (here we can show or hide the axis)

How to Customize Tables in Google Data Studio 52

How to Customize Tables in Google Data Studio 53

We can set its font color

How to Customize Tables in Google Data Studio 54

Also, the Font family

How to Customize Tables in Google Data Studio 55

We can use Axis compact numbers checkbox to enable packed numbers (1000 as 1K)

How to Customize Tables in Google Data Studio 56

We also have axis decimal precision drop down here

How to Customize Tables in Google Data Studio 57

Customize Tables in Google Data Studio – Change Background and Border Color

In this section, we will learn how to customize tables in Google Data Studio and will glance at the background and border.

Step 1

Footer background color

How to Customize Tables in Google Data Studio 58

Step 2

Border radius

How to Customize Tables in Google Data Studio 59

Step 3

Overall border opacity

How to Customize Tables in Google Data Studio 60

Step 4

Outer border-color

How to Customize Tables in Google Data Studio 61

Step 5

Outer border weight

How to Customize Tables in Google Data Studio 62

Step 6

Add border shadow checkbox (adds a slight shadow to the outer border)

How to Customize Tables in Google Data Studio 63

Step 7

Chart header Dropdown

How to Customize Tables in Google Data Studio 64

We can select any option from always show, don’t show, or show on hover

Note: Chart header here is not meant for column headers, chart header is just a header area where we have a three-dot menu button on the right side and a reset button on the left.

Also note that showing on hover means hovering anywhere on the chart, and not on the actual header position.

We can also select the color for chart elements

How to Customize Tables in Google Data Studio 65

Step 8

Finally, we have a “Reset to report theme” button, that will reset all the styling to default

How to Customize Tables in Google Data Studio 66

So, this was a complete styling guide specifically for tables in Google Data Studio, we have some similar and some different styling options for each chart, we will also learn styling for other charts in detail to never miss any useful feature while working with our reports.

I hope you have understood all the key features of table styling, and you will not forget to style your tables like a pro.

Important Notes

  • All the above options are for tables chart, we may have some same and some other styling options for other charts (we will learn later in this series of tutorials)
  • Conditional formatting is also a part of customization, we will learn it in a dedicated article very soon.
  • The reset button can be used to reset to report theme if you have messed up your table chart with so many colors and styling.

Frequently Asked Questions

How to customize charts in Google Data Studio?

In the above article, we learned how to customize tables in Google Data Studio, tables are kind of charts that can be used to visualize data in the form of tables, other charts such as pie charts, time series charts, bar charts, Google maps charts, scorecards, etc. can also be customized like above, we need to create a chart first, then select it and go to the second tab, which is Style tab, and completely dedicated for the styling of charts.

Can I have different customization for different tables in Google Data Studio?

Of course. Charts are mutually exclusive from other charts even within a single page or canvas, we have a unique Chart box for each chart, and we can have different formatting, color, styles, font, and everything for our different charts. If I have two table charts on a single same page even with the same dimensions and metrics, still i can style both of them separately, when you select a chart it has a chart box, when you select multiple charts, then there is no chart box in the sidebar, which means that you cannot customize more than one chart at once, because they all can be of different styles and customizations.

Conclusion

Wrapping up how to customize tables in Google Data Studio, I did not skip any small thing, I covered the table chart style tab from beginning to end in some sections, I hope you have learned and understood all the style features and customization options for a table chart. There are some features that have dependability, like when you uncheck the show header checkbox, then understandably the rest of the options for that headers are unavailable.

I hope you understand this. I will see you next time with another helpful tutorial. Keep learning with us. Thank you.

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq, I am a highly skilled technical writer working full-time for Office Demy. I am specialized in Google Workspace and Microsoft Office applications. With a background in Software Engineering, I possess a deep understanding of the intricate functionalities and features of these productivity tools. Connect me on Linkedin https://www.linkedin.com/in/shaiq-ansari/

OfficeDemy.com
Logo
Enable registration in settings - general