Change text of chart tips?

[Rob]

I would like to change the text of a tool/hover tip for a datalabel in a chart
using Excel 2003. As it is, I can use the

Application.ShowChartTipNames
and
Application.ShowChartTipValue

to either turn on or off the names and values. If, say, I turn on
names but not values, then the datalabels for the series named "Category 1"
would read

"Category 1" Data Labels.

That's close, but I'd prefer that the tip simply read

Category 1

or whatever else I choose. Is there a .caption property or some such
that I can change somewhere?

Can this be done?

Thanks,
Rob

[FunkyFox]

Hi Rob,

I'm doing something pretty similar and drew a blank with the standard 'chart tips'.

I've created a new chart class and am using the MouseMove event with GetChartElement to set the datalabels for the corresponding points.

It seems to be working ok (in 2007 at least) and wasn't as difficult as it first seemed. The added bonus is you can use pretty much any text you like and are not just limited to series names,

Hope this helps,

Jeff