Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Load ws cell data into a textbox via click on chart datapoint a Charts and Charting in Excel 4 January 23rd 09 08:08 PM
Oriented datapoint markers on chart [email protected] Charts and Charting in Excel 2 October 30th 07 04:37 PM
Customize Text for Pausing Over Chart Datapoint roadkill Excel Programming 1 November 25th 06 07:17 PM
Accessing Tooltip Data in an Excel Chart MikeM Excel Programming 6 April 30th 06 08:33 PM
Change the tooltip text for a datapoint Hayeso Charts and Charting in Excel 4 December 16th 05 01:33 PM


All times are GMT +1. The time now is 10:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"