PDA

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)