TipText Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.  

TipText property as it applies to the ChSeries object.

Returns or sets a String that represents the chart ScreenTip text for the specified data series. The chart ScreenTip text is formatted with tokens that represent the values associated with the chart ScreenTip. The following table describes the tokens that can be used to set the ScreenTip text. Read/write.

Token Description
 <N> Where N is a dimension number, returns the name of the dimension.
<value> For data series bound to a PivotTable list, returns the name of the pivot aggregate. Returns the word "Value" for data series that are not bound to a PivotTable list.
<ls> Returns the list separator.
<br> Inserts a line break.
<< Returns the "<" symbol.

expression.TipText

expression   Required. An expression that returns a ChSeries object.

 

TipText property as it applies to the OCCommand object.

Returns a String that represents the ScreenTip text of the specified command. Read-only.

expression.TipText

expression   Required. An expression that returns an OCCommand object.

Remarks

The OCCommandId, ChartCommandIdEnum, PivotCommandId, and SpreadsheetCommandId constants contain lists of the supported commands for each Web component.

 

Example

As it applies to the ChSeries object.

  Sub SetChartTips()

 ' Set the tiptext for Series1.
 Chartspace1.Charts(0).SeriesCollection(0) _
      .TipText = "<1>:<value>:<2>"

End Sub