The reason Tushar wrote his add-in is that there's no way to alter the
chart-tip text. Whatever flickering you see is unavoidable.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"daithi" wrote in message
ps.com...
(Using Excel 10.1.8 on Mac OSX)
Is there any way yet of changing the text of the tooltip which appears
when the mouse hovers over a datapoint in an Excel Chart?
I know there are solutions using Chart_MouseMove and showing and
hiding labels, (Mehta Tushar's add-in?), but this is a bit slow and
causes the text in the "Name box" to continually flicker as the
MouseMove is fired.
What I really want is a scattergraph where each point represents a
person (whose name should appear in the tooltip when the mouse moves
over). The only way I can think of 'editing' the tooltip is to plot
each point as a separate series and give them the relevant names (and
just suffer the extra "Series..." and data value parts of the
tooltip).
If anyone knows how the tooltip can be accessed please let me know.
Thanks