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