Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Unknown Object
When I hover over a point on an Excel chart a "comment-like" box pops up to tell me information about that point such as : 1) Which Series it is from 2) Which point on that Series it is 3) The X and Y co-ordinates of that point. Note that this is NOT the Label as it is NOT always visible. Can anyone tell me what this Object is called and how can I control/change the text that appears in it. I have a With Events Chart Class and have managed to add an 'X and Y tracker' (appearing on the Status bar) when I move my mouse around the chart - just to give you some idea of where I'm at. Thanks for any help that you can give Chris -- Chris Laycock ------------------------------------------------------------------------ Chris Laycock's Profile: http://www.excelforum.com/member.php...o&userid=19996 View this thread: http://www.excelforum.com/showthread...hreadid=345824 |
#2
|
|||
|
|||
Chris -
This is the Chart Tip, equivalent to the Tool Tip on a command bar item. You have no easy way to access this Chart Tip. Tushar Mehta has an add-in which allows you to define custom labels when hovering the mouse over a chart (http://tushar-mehta.com, look for Hover Labels). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Chris Laycock wrote: When I hover over a point on an Excel chart a "comment-like" box pops up to tell me information about that point such as : 1) Which Series it is from 2) Which point on that Series it is 3) The X and Y co-ordinates of that point. Note that this is NOT the Label as it is NOT always visible. Can anyone tell me what this Object is called and how can I control/change the text that appears in it. I have a With Events Chart Class and have managed to add an 'X and Y tracker' (appearing on the Status bar) when I move my mouse around the chart - just to give you some idea of where I'm at. Thanks for any help that you can give Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) | |||
Chart Wizard "as object in:" turned off | Excel Discussion (Misc queries) | |||
"Excel.Application" Object Model | Charts and Charting in Excel | |||
Can't save chart as object in current sheet | Charts and Charting in Excel | |||
pivotcell object to excel 2000 | Excel Discussion (Misc queries) |