Tushar Mehta has a utility that does something like this. Look for Auto
Chart Hover on his website (http://tushar-mehta.com). Otherwise you'll need
to use some kind of chart events to detect when you have moused over
something significant, and populate the textbox accordingly. For a primer on
chart events, look he

http://www.computorcompanion.com/LPMArticle.asp?ID=221

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"a" wrote in message
...
Not sure if this is a chart question or programming question.

If I have data in a worksheet like this:
A B C
1 Date Number Text
2 2 Dec 2000 234 Sunny Day
3 1 Dec 2000 117 Wrecked My Car

and I create a line chart, I'd like to be able to hover or click the mouse
on the data point in the chart and have the text from column C load into a
textbox (the text may be many paragraphs long).

Are there any ways to do this, either with VBA, C# or other techniques?

Thanks, Paul