Text
Text objects complements other visualizations by offering options to add text, hyperlinks, and measures. You can also add background images.
You can format and color the text and align the paragraphs. The background image has sizing and positioning options.
Text is only available in the advanced edit mode.
When to use it
Text is intended for presentation purposes, and does not support selections. However, the measures in Text are updated when selections are made. Some typical uses:
- Use it on the first sheet of an app for essential information.
- Display a company image as a background image together with formatted text and measure values to present figures in a compelling way.
- Link to sites with additional information.
Advantages
Text contrasts with the other visualizations. You have many options for making Text stand out next to more regular charts.
Disadvantages
When organizing content within the chart, it is advised to use only a few measure values and shorter texts. Otherwise, Text will be cluttered.
Creating Text objects
You can create a Text on the sheet you are editing.
Do the following:
- In the advanced edit mode, drag an empty Text to the sheet from the assets panel.
-
Click Text to open the editing toolbar.
-
Add and format text, tables, hyperlinks or measures to Text.
Styling and formatting text in Text
Text offers several editing and formatting options for text. You can format your text using several styles:
-
Paragraph
-
Quote
-
Heading 1
-
Heading 2
-
Heading 3
-
Unordered list
-
Ordered list
You can also select font families and size. You can apply emphases to your text and change text color. You can also add hyperlinks.
Styling and formatting tables in the Text
You can insert tables into Text from the toolbar. You can resize column and rows and hide borders. You can insert additional tables inside table cells.
Styling Text
With Advanced options turned on, you have a number of styling options available under Appearance in the properties panel.
Click Styling under Appearance > Presentation to further customize the styling of the chart. The styling panel contains various sections under the General and Chart tabs. You can reset your styles by clicking next to each section. Clicking Reset all resets styles for all available tabs in the styling panel.
Customizing the text
You can set the text for the title, subtitle, and footnote under Appearance > General. To hide these elements, turn off Show titles.
You can style the text that appears in the chart.
Do the following:
-
Click Advanced options.
-
In the properties panel, expand the Appearance section.
-
Under Appearance > Presentation, click Styling.
-
On the General tab, set the font, emphasis style, font size, and color for the following text elements:
-
Title
-
Subtitle
-
Footnote
-
Customizing the background
You can customize the background of the chart. The background can be set by color and image.
Do the following:
-
Click Advanced options.
-
In the properties panel, expand the Appearance section.
-
Under Appearance > Presentation, click Styling.
-
On the General tab of the styling panel, you can select a background color (single color or expression). You can also set the background to an image from your media library or from a URL.
Information noteTo add a background image from a URL, the URL's origin needs to be added to the allowlist in your tenant's Content Security Policy. The origin must be added with the following Directive: img-src. This is done by a tenant administrator.
For more information, see Creating a CSP entry.
When using a background color, use the slider to adjust the opacity of the background.
When using a background image, you can adjust image sizing and position.
Customizing the border and shadow
You can customize the border and shadow of the chart.
Do the following:
-
Click Advanced options.
-
In the properties panel, expand the Appearance section.
-
Under Appearance > Presentation, click Styling.
-
On the General tab of the styling panel, under Border, adjust the Outline size to increase or decrease the border lines around the chart.
-
Select a color for the border.
-
Adjust the Corner radius to control the roundness of the border.
-
Under Shadow in the General tab, select a shadow size and color. Select None to remove the shadow.
Creating a link
You can mark a text section and use it for a link.
Do the following:
-
Select the text section that you want to use for the link.
-
Click in the editing toolbar to open the link dialog.
-
Enter the web address that you want to link to.
-
Click .
Removing a link
You can remove a link from a text section.
Do the following:
-
Click the link so that the cursor is somewhere inside it.
-
Click in the editing toolbar to open the link dialog.
-
Click .
The link is removed, but not the text.
Adding a measure
You can add a measure in the following ways:
- By dragging a field from the assets panel and adding it as a measure.
- By dragging a measure from Master items.
- By adding a measure (existing or new) from the properties panel.
When you are editing the measure, it is displayed as a value with a grey background, which can be styled and moved around in the visualization. You can also apply number formatting to it. When you leave the editor, the measure value is displayed . Values that cannot be aggregated are shown as a hyphen (-).
Deleting a measure
You can delete a measure in the following ways:
- Place the cursor before the token and press Delete.
- Place the cursor after the token and press Backspace.
- In the properties panel, right-click the measure and select Delete in the dialog.
- In the properties panel, click the measure and click Delete.
Limitations
You can add a maximum of 10 measures to this chart.