LabelTexts

LabelTexts ( seriesIndex ;​ text1 ;​ text2 ;​ . . . ;​ text10000 )

Argument Type Range Default Note
seriesIndex int -1..10000 all
text1 str 0..1000 "|u|" Max. 1000 chars.
text2 str 0..1000 "|u|" Max. 1000 chars.
... str 0..1000 "|u|" Max. 1000 chars.
text10000 str 0..1000 "|u|" Max. 1000 chars.
Examples

LabelTexts(2;​"")

LabelTexts(all;​"|2f1|%")

Description

The LabelTexts() function makes it possible to assign different texts to the data points of a chart. In doing so, texts can be set up in a variety of ways.


• Text Only

Texts are to be placed in double quotes. Please note, a prefixed backslash is required when entering quotes in FileMaker's Specify Calculation dialog box. For more details refer to Texts.

LABEL_TEXTS_01
1

OpenDrawing(250;​150)

2

ChartData(0.5555 1.61 1.2 2.365)

3

BarChart(label+horizontal+shadow;​50)

4

/* Set up styles. */

5

FillStyle(1;​#cbdb29)

6

BorderStyle(1;​none)

7

ShadowStyle(all;​2 2 3)

8

LabelStyle(1;​Verdana;​10;​plain;​black;​left;​;​-2;​-2)

9

LabelTexts(1;​"1st Quarter";​"2nd Quarter";​"3rd Quarter";​"4th Quarter")

10

/* Set up axes. */

11

ScalingOptions(y;​on) /* y-scale top to bottom. */

12

AxisLine(all;​0)

13

AxisMajorTicks(all;​0)

14

AxisMajorTickLabelTexts(y;​"A";​"B";​"C";​"D")

15

AxisMajorTickLabelOptions(y;​;​-3)

16

/* Set up grid. */

17

MajorGridLineWidths(y;​x;​0.25)

18

MajorGridLineWidths(x;​y;​0)

19

CloseDrawing()

LABEL_TEXTS_01
• Format Specifier

A format specifier must always be placed between two vertical bars (pipe characters), for example: "|f2|". A detailed explanation of all format specifiers, including numerous examples, can be found in Numbers and Date & Time.

LABEL_TEXTS_02
1

OpenDrawing(250;​150)

2

ChartData(-1.5 0.024 3 1.121 1.5)

3

LineChart(label+symbol+shadow;​on)

4

/* Set up styles. */

5

LineStyle(1;​poly;​1.5;​crimson)

6

SymbolStyle(1;​circle;​6;​1;​crimson;​;​white)

7

ShadowStyle(all;​2 2 3)

8

LabelTexts(1;​"|f2|")

9

LabelOptions(1;​topCenter)

10

LabelBackground(1;​#fffc;​;​0)

11

/* Set up axes. */

12

AxisLine(all;​0)

13

AxisMajorTicks(all;​0)

14

/* Set up grid. */

15

MajorGridLineWidths(x;​y;​0.25)

16

MajorGridLineWidths(y;​x;​0)

17

CloseDrawing()

LABEL_TEXTS_02
• Combination of Text and Format Specifier

As an option, texts can be added before and after a format specifier.

LABEL_TEXTS_03
1

OpenDrawing(250;​150)

2

ChartData(135 90 135)

3

PieChart(label+oval+shadow)

4

/* Set up styles. */

5

FillStyle(1;​#ffb400;​shaded)

6

FillStyle(2;​#f81a53;​shaded)

7

FillStyle(3;​#0073dd;​shaded)

8

BorderStyle(all;​none)

9

ShadowStyle(all;​2 2 3)

10

LabelTexts(1;​"A (|u|)";​"B (|u|)";​"C (|u|)")

11

LabelStyle(1;​Verdana;​10;​plain;​black)

12

CloseDrawing()

LABEL_TEXTS_03

On pie charts and stacked bar and area charts it is also possible to represent both absolute values (default) and percentage values. This can be done by specifying two format specifiers. The first specifier defines the format of the absolute values; the second format specifier serves to format the percentage values.

LABEL_TEXTS_04
1

OpenDrawing(250;​150)

2

ChartData(135 90 135)

3

PieChart(label+oval+shadow)

4

/* Set up styles. */

5

FillStyle(1;​#ffb400;​shaded)

6

FillStyle(2;​#f81a53;​shaded)

7

FillStyle(3;​#0073dd;​shaded)

8

BorderStyle(all;​none)

9

ShadowStyle(all;​2 2 3)

10

LabelTexts(1;​"|u|\n(|f1|%)")

11

LabelStyle(1;​Verdana;​10;​plain;​black;​center)

12

CloseDrawing()

LABEL_TEXTS_04

If only the percentage values are to be represented, the output of the absolute values has to be suppressed by an empty format specifier "||".

LABEL_TEXTS_05
1

OpenDrawing(250;​150)

2

ChartData(135 90 135)

3

PieChart(label+oval+shadow)

4

/* Set up styles. */

5

FillStyle(1;​#ffb400;​shaded)

6

FillStyle(2;​#f81a53;​shaded)

7

FillStyle(3;​#0073dd;​shaded)

8

BorderStyle(all;​none)

9

ShadowStyle(all;​2 2 3)

10

LabelTexts(1;​"|||f1|%")

11

LabelStyle(1;​Verdana;​10;​plain;​black)

12

CloseDrawing()

LABEL_TEXTS_05
LABEL_TEXTS_06
1

OpenDrawing(250;​150)

2

ChartData(5 4 9;​ /* 1st series. */

3

4 5 10;​ /* 2nd series. */

4

2 2 12) /* 3rd series. */

5

BarChart(horizontal+proportional+label+shadow;​60)

6

/* Set up styles. */

7

FillStyle(1;​#005ca9)

8

FillStyle(2;​#00afef)

9

FillStyle(3;​#cbdb29)

10

BorderStyle(all;​none)

11

ShadowStyle(all;​2 2 3)

12

LabelTexts(all;​"|||f1|%")

13

LabelStyle(all;​Verdana;​10;​bold;​white)

14

LabelStyle(3;​Verdana;​10;​plain;​black)

15

/* Set up axes. */

16

Scaling(x;​percent;​0;​100;​4)

17

ScalingOptions(y;​on) /* y-scale top to bottom. */

18

AxisLine(all;​0)

19

AxisMajorTicks(all;​0)

20

/* Set up grid. */

21

MajorGridLineWidths(x;​y;​0)

22

MajorGridLineWidths(y;​x;​0.25)

23

CloseDrawing()

LABEL_TEXTS_06

Texts and format specifiers are repeated periodically if the number of chart values is larger than the number of text arguments. If no specifier is entered, the default format specifier "|u|" is used. Furthermore, texts consisting of several lines are possible by inserting a line feed "\n".

Scroll to Top
Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×