TipText Property

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 member of the ChartDimensionsEnum class. It returns a value from the series based on the dimension. For example, <1> will return the category name/label from the series. Similarly <4> will return the X-value if the series is an XY (Scatter) chart. If <N> is invalid for the series, the tip text will not be displayed.
<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

Applies to | ChSeries Object | OCCommand Object