View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
A A is offline
external usenet poster
 
Posts: 37
Default Load ws cell data into a textbox via click on chart datapoint

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