Customize Text for Pausing Over Chart Datapoint

[Guest]

When you pause the cursor over a bar or pie piece or line on a chart, a box
pops up that gives information about that data point. Is there a way in VBA
to recognize that the cursor is paused over a bar/pie piece/line and replace
the text showing in that box with my own? It would also be nice to have a
way to reset things so that the default information returns.

Thanks,
Will

 

[Jon Peltier]

Try this add-in from Tushar Mehta's site:

http://tushar-mehta.com/excel/software/chart_hover_label/index.html

- Jon