Wednesday, February 12, 2014

Chart Web Part Series Hyperlink series properties

I was trying to use the settings on the Chart web part and went looking for a how to from Microsoft.  Problem is that this was part of the Dundas library originally.   Found this article http://social.msdn.microsoft.com/Forums/sharepoint/en-US/873fe5fc-91f0-429c-89d2-2c1fb7bff1ba/chart-web-part-series-hyperlink-links-incorrectly?forum=sharepointgeneralprevious
Which talked about how to build a drill down capability based on a guide from Dundas
 (http://support2.dundas.com/Default.aspx?article=1205)

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:
KeywordReplaced ByData Comes From
#VALXX value of the data point.Data point
#VAL, #VALY, #VALY2, #VALY3, …Y values of the data point.Data point
#SERIESNAMESeries name.Series
#LABELData point label.Data point
#AXISLABELAxis data point label.Data point
#INDEXData point index.Data point
#PERCENTPercentage of the data point Y value.Data point
#TOTALTotal of all Y values in the series.Series
#AVGAverage of all Y values in the series.Series
#MINMinimum data point of all Y values in the series.Series
#MAXMaximum data point of all Y values in the series.Series
#FIRSTFirst data point of all Y values in the series.Series
#LASTLast 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".


Source:
http://support2.dundas.com/Default.aspx?article=1132

No comments:

Post a Comment