QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

Chart texts

Text

Enter a text that should be displayed in the chart. The text entered can also be defined as a calculated formula for dynamic update. Click the ... button to open the Edit Expression dialog for easier editing of long formulas or for typing multi line text.

Expression syntax for calculated formulas

Font Opens the standard font dialog where a font for the text can be specified.
On Top Forces the text to the foreground when the chart is drawn.
Background

Defines the background of the text.
Transparent
With this option, only the text itself will be visible. Any sheet object covered by the text will be fully visible.
Fixed
This option lets you pick a background color by clicking the Color button to the right of the radio button.
Calculated
The background color may be dynamically calculated from an expression. The expression must be a valid color representation, which is achieved by using color functions. Click the ... button to open the Edit Expression dialog for easier editing of long formulas. If the result of the expression is not a valid color representation, the program will default to black.

Color functions

Angle (degrees) Specifies the angle for the text. 0 to 360 degrees is allowed, the default value is 0.
Alignment Sets the horizontal alignment of the text within its background.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?