copy graphs values in a cell

[bluepill]

I am looking for a way to click on a specific data point of a graph and have
the data related to that, copied in one or more cells..like click on point
x1,y1 belonging to Graph1, and have the values of x1 and y1 copied in cells
A1 and A2 in Sheet1
I guess I need a macro... You think it might be possible?

ps sorry for my poor english

 

[Andy Pope]

Hi,

Yes you will need VBA code. Have a look at Jon Peltier's article on
chart events.
http://www.computorcompanion.com/LPMArticle.asp?ID=221

Cheers
Andy

 

[bluepill]

"Andy Pope" <[email protected]> ha scritto nel messaggio
| Hi,
|
| Yes you will need VBA code. Have a look at Jon Peltier's article on
| chart events.
| http://www.computorcompanion.com/LPMArticle.asp?ID=221
|
| Cheers
| Andy


You are great!!!
thank you very much... lots to work on, and very interesting solution and
topic!!!
thank you from Rome, Italy...

 

[Bernard Liengme]

Why reinvent the wheel; look here fro inexpensive software that does what
you want. I have used it fro years (it used to be free!)
http://www.datatrendsoftware.com/
best wishes