Styling a Table on a Grid Page
You can style the appearance of a table on a grid page by changing fonts, colors, alignment, and so on.
Context
Options for styling a table on a grid page are different from the options for styling a table on a canvas page. For information on styling a table that is included on a canvas page, see Styling Options for Tables on a Canvas Page.
Procedure
- Select a table.
-
Freeze or unfreeze rows and columns.
-
Show or hide table elements.
- Select one or more cells.
-
Open the Designer panel and select
(Styling).
- Apply styling options.
Results
The available options change depending on which area of the table you are in.
-
Table Properties
Styling Options
Description
Templates
Apply a preset template to the table:-
Default
Includes different column heading lines for each type of planning version (Actual, Forecast, and so on).
Color Fill for Editable Cells: Provide a color for cells that can be edited.
-
Report Styling
Not every option is available for every template:- Frequency of Reading Lines: Changes the number of lines displayed for ease of reading. By default this is set to one line per row.
- Show group lines: Displays a line around groups in the table.
- Alternating Rows
-
Basic (previously Standard)
A simple design that includes gridlines and shading for row and column headings.
Drill Icon Lets you choose the color of the drill icon. This makes it easier to see the expand/collapse arrows in your table after you've changed the background color.
Threshold Style Changes how threshold cell data is displayed.- Symbol (default) – use the story-defined symbols and colors for the threshold ranges.
- Color Values – the threshold colors are applied to the cell data.
- Color Background – the threshold colors are applied to the cell background.
- Color Background Without Values – the threshold colors are applied to the cell background and the values are hidden.
-
-
Style
A Default style is applied to all cells.
You can create a new style which can be applied to cells in the current table, or to cells in other tables in the story:-
Select
(Add Style).
-
Enter a name for the style.
-
Choose a font and other options.
-
Apply the changes.
-
-
Formatting Rules
You can cascade text style changes along hierarchies, either to siblings, descendants, or children. The style changes are also applied to new members in the hierarchy.
-
Select a table cell.
-
Select Add Formatting Rule.
-
Provide a name for your rule.
-
Select the level to apply the formatting to:
- Self
- Self & Children
- Self & Siblings
- Self & Descendants
- Children
- Descendants
-
Select an existing style or create a new one.
-
Set the Read-Only Settings:
- Not applied
- Read-only
- Editable
-
When finished, select OK.
The table cells are updated with the new style.
-
-
Font
You can change the following options:
- Text Selection
- Font
- Size
- Color: choose from available colors or choose More to display the color selector and opacity selector.
- Style
- Alignment
-
Cell
Styling Options
Description
Merge
Merge cells.
Fill
Choose from available colors or choose More to display the color selector and opacity selector.
Wrap
Choose to wrap text for a cell or for a column.
Row
Add or delete a Row: the selected cell must be above or below the table.
Column
Add or delete a Column: the selected cell must be to the right or the left of the table.
-
Lines
Add lines to selected area or cell:
-
Simple Line: a narrow line between cells.
-
Decoration Line: a wider line between cells.
For each line, you can set different values:-
Alignment
-
Line width
-
Color
-
Pattern
-
Style
-
Left Padding or Right Padding: you can add padding to the left or right side of a cell.
-
-
Number Format
Styling Options
Description
Measure Selection
Choose an included measure to apply the formatting to.
Scale
Select how to display the numbers on an axis: whether to show all digits for each data point or to display the values as thousands, millions, or billions.
-
Unformatted
-
Thousand
-
Million
-
Billion
-
Auto-formatted: picks the best scale for the values.
For example, if the values are below zero when the number format is set to Million, then Auto-formatted changes the format to Thousand.
Scale Format
- Default
- k, m, bn
- Thousand, Million, Billion
Display unit / Currencies
Select whether to display scale units and currencies in the same cell as the numeric value or in a row or column header.
Decimal Places
Select the number of decimal places to display.
Show Sign As
- Default
- + / -
- ( ): brackets will appear around negative values instead of a minus sign.
Select
(Reset to auto) to undo any changes, and return all table values to the default unit setting.
-