TipMask with xlabels - very urgent(Please help - Attached a descriptive chart)

[Mohamed]

Sorry I am frequently posting many question( to meet my deadline).

This question is my most wanted one:

When I keep the mouse on the interactive bars on the chart, I was able to produce tooltip with actual values bar with the below code.

chart1.TipMask = "%v%x"<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

But I want to display the corresponding Xaxis labels as the tooltip.(Attached descriptive chart Image for this question).

Thanks

Mohamed

[Frank]

Use %l to display the X-Axis label (instead of %x).

Please review the documentation for the TipMask property:

• The syntax for this property is the same as the one used in the PointLabelMask property. Variables can be accessed using the % following the variable you want to include:

   

  l Shows X-Axis Legend.

  k Shows X-Axis Key Legend.

  s Shows Series Legend.

  S Shows the Series Index.

  x Shows XValue (XY charts, when they were set with X values).

  i Shows IniValues (Gantt).

  v Shows Data Value.

  v <n> For types that require more than one series, these are replaced by the value of each one. (n represents an index).

  t Series Total (Sum of all points in this series).

  p Percentage of total this point represents (Pie).

  T Point Total (Sum of all series for this point).

  P Percentage of total this series represents (Used in stacked charts).

  X displays the marker X value for any chart type including those that do not support X values such as bar.

  N Shows the index for the point.

  L Shows the Tag string of the Point object.

• This property is write-only.