(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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> (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
>

Yes, I assumed there was no way of editing the tool-tip when Tushar
wrote the add-in. I was wondering if there is now, but I take it there
still isn't.
Thanks again
Daithi

No, unfortunately this has not changed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"daithi" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Yes, I assumed there was no way of editing the tool-tip when Tushar
> wrote the add-in. I was wondering if there is now, but I take it there
> still isn't.
> Thanks again
> Daithi
>