This article describes customization of tables in terms of re-order of row and column headings and using conditional formatting.
Reorder rows and columns headings
Once you have created a table, you may want to customize it. By default, headers in a table appear in the order that the user selected them in.
If you want to change the order, follow these steps:
- Switch to custom mode (click the Cog icon on Dimension > Filter tab).
- Select C (Columns) if you need to add headers to columns, R (Rows) if you need to add additional columns with metadata in the order you want them to appear on your table.
Using conditional formatting for tables
Once you have created a table, you may want to customize it. Go to Appearance tab > click Conditional formatting
Here you have two options: add a heat map or highlight some data.
Heatmap
You can change a number of ranges, change color of ranges. Then go back to global options and save gadget.
Highlight
There are two options:
You can highlight US recession data and forecasted data.