View Full Version : Chart Series info in tipbox?
dumanibo
02-06-2007, 04:37 AM
Hello,
How can I show a chart series or a point info in a special tipbox when the mouse over a point of a chart. Is it possible?
JimmyTheHand
02-06-2007, 11:22 PM
Hi and welcome to VBAX!
When you move the mouse pointer over a point in an (X,Y) type chart, Excel will automatically display the point's properties in a tipbox, without need of any macro or such. This applies to Excel 2002 and, I guess, up.
If this is not what you need, then please explain in detail what it is.
Jimmy
dumanibo
02-07-2007, 02:40 AM
Thank you Jimmy for your interest.
I know Excel's automatic tipbox but I want to make specialized this tipbox. For example I want to show a point's tipbox another series value. Maybe it can do some API. How can do it? Is it possible?
Andy Pope
02-07-2007, 05:44 AM
Tushar Mehta has an addin to handle this,
Hover Chart Label (http://tushar-mehta.com/excel/software/chart_hover_label/index.html)
And Jon Peltier has written an article on chart events if you need to roll your own code.
Chart Events (http://www.computorcompanion.com/LPMArticle.asp?ID=221)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.