Using Labels

CMaps Plugin and GMaps Plugin provides basic controls over text formatting via the Appearance tab. Using SAP Dashboards concatenation formulas you can concatenate dynamic labels using HTML. Using basic HTML creates an opportunity for rich content like images, charts, and links to other content

NOTE FOR Â CMAPS PLUGIN: Introduced with CMaps Plugin is a new InfoWindow designer property to over-write labels and provide much more flexibility when there are more than 1000 points in the map. InfoWindow Designer

Including a Value inside of the label

Because CMaps Plugin & GMaps Plugin can not display number formatting by default, it is a common practice, to display the value alongside the label. You must manually define the numeric formatting for values using the TEXT() formula and concatenate. Syntax = TEXT([number],”[format”]
Examples: TEXT(A1,”$#,###”) TEXT(A1,”#%) TEXT(A1,”mm/dd/yyyy”).

EXAMPLE:

Note: You can hide the value property from the InfoWindow, by going to the Appearance tab, and unchecking “Show Value”Â

RESULTING LABEL:

Using HTML and the Labels Property

To use HTML code within a label, all label data must be enclosed in <HTML></HTML> tags. CMaps Plugin and GMaps Plugin will support common HTML functionality like text formatting, line breaks, images, URLs, and bulleted lists. The labels property also provides dynamic control over the pop-up window size using the following format w:#;h:#<HTML</HTML>. “w:” is width and “h:” is height.

BASIC SYNTAX EXAMPLE: w:300;h:400<HTML>CONTENT</HTML>

NOTE- When using HTML format, the label style configuration will no longer be active. To modify the label font and alignment, you will need to do so inside of the <HTML> tags.

[ezcol_1third]

SAMPLE FORMULA:

=”w:180;h:150″&”<HTML>”&B14&” ”&G14&” ”&TEXT(H14,”$#,###”)&” ”&TEXT(I14,”$#,###”)&” ”&F14&” <HTML>”

[/ezcol_1third] [ezcol_1third]

RESULTING LABEL TEXT:

w:180;h:150<HTML>Australia <a href=”http://gmapsplugin.com”>Website Link</a> $2,500 $2,300 <img src=”http://www.centigonsolutions.com/components/images/icon_background.jpg” /> <HTML>

[/ezcol_1third] [ezcol_1third_end]

RESULT LABEL DISPLAY

[/ezcol_1third_end]

Supported HTML

Images
When displaying images in the CMaps Plugin it will not resize itself to the image automatically. To ensure the entire image will load, you will need to define the info window width and height.

Example: w:300;h:400<HTML>CONTENT</HTML>

IMPORTANT NOTE
When concatenating HTML, opening and closing quotes are reserved characters for concatenate. To introduce double quotes, you will need to enter them into a cell and reference the cell.

Example formula where A1=”

=”<img src=”&A1&”http://servername/image.jpg”&A1&”/>”
Resulting HTML

Font Styling
Example: UK

Bullet List
Example: <ul><li></li><li></li></ul>

Example:Â <ol><li> </li><li></li><ol>

Link
Example: <a href=”http://centigonsolutions.com”>web site</a>

Label Styles

Control the appearance of the label values, as they are displayed in a popup window, when each series marker is selected. Labels can be formatted using a comprehensive list of system fonts, standard colors, alignment options and bold, italic and underline font decorations.