| GMaps Plugin provides basic controls over text formatting via the Appearance tab. For complete control over labels, GMaps Plugin supports HTML text. Dynamically concatenating labels and values with HTML creates an opportunity for rich content like images, charts, and links to other content.
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.
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><FONT> tags.
Using HTML
To use HTML code within a label, all label data must be enclosed in <HTML></HTML> tags. 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>.
Example: w:300;h:400<HTML>CONTENT</HTML>
Apply text number formatting
Because GMaps Plugin can not consume number formatting by default, you must manually define the numeric formatting for values using the TEXT() formula. Syntax = TEXT([number],"[format"]
Examples: TEXT(A1,"$#,###") TEXT(A1,"#%) TEXT(A1,"mm/dd/yyyy")
Supported HTML
Images
When displaying images in the Google Maps info window, GMaps Plugin 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
<img src="http://servername/image.jpg"/>
Font Styling
Example: <FONT SIZE='11' face='Verdana'><b>UK</b><br>
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> |
