ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   edit chart datapoint tooltip (https://www.excelbanter.com/excel-programming/383402-edit-chart-datapoint-tooltip.html)

daithi

edit chart datapoint tooltip
 
(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


Jon Peltier

edit chart datapoint tooltip
 
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




daithi

edit chart datapoint tooltip
 
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


Jon Peltier

edit chart datapoint tooltip
 
No, unfortunately this has not changed.

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


"daithi" wrote in message
oups.com...
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





All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com