Dundas Data Visualization Support Site
Dundas Support Site Home  |  Contact Us  |  Dundas Data Visualization  
Contact Us via Email
Home

Built-In Keywords for Series Properties

 

Dundas Chart comes with built-in keywords that you can use in any combination for data point tooltips, labels, hyperlinks and legend text. This lets you easily display all kinds of information about your points in different ways.

Here is a list of all available keywords:

Keyword Replaced By Data Comes From
#VALX X value of the data point. Data point
#VAL, #VALY, #VALY2, #VALY3, … Y values of the data point. Data point
#SERIESNAME Series name. Series
#LABEL Data point label. Data point
#AXISLABEL Axis data point label. Data point
#INDEX Data point index. Data point
#PERCENT Percentage of the data point Y value. Data point
#TOTAL Total of all Y values in the series. Series
#AVG Average of all Y values in the series. Series
#MIN Minimum data point of all Y values in the series. Series
#MAX Maximum data point of all Y values in the series. Series
#FIRST First data point of all Y values in the series. Series
#LAST Last data point of all Y values in the series. Series

You are free to use these keywords in any of the following series properties, available both from our wizards and our Advanced Properties:

  • Label
  • LegendText
  • Href ("Hyperlink"), LabelHref ("Label Hyperlink"), and LegendHref ("Legend Hyperlink")
  • ToolTip, LabelToolTip, and LegendToolTip
  • MapAreaAttributes, LabelMapAreaAttributes, and LegendMapAreaAttributes

For example, here is how you can set a tooltip to display the X-value, Y-value, series name and percentage of the total series values:

X: #VALX  Y: #VALY  Series: #SERIESNAME  %: #PERCENT

To add the average and total to the series name in the Chart's legend, set the Series' LegendText property to:

#SERIESNAME - Total: #TOTAL - Avg: #AVG

You can format numeric and date/time values, too, by adding a Microsoft format string to the keyword. For example: "#VALY{N2}" formats the Y-value to have two numbers after the decimal place. For help formatting series properties, see this support site article. For more information on format strings, see "Numeric Format Strings" or "Date and Time Format Strings".

PoorExcellent