Thread: copy graphs values in a cell

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

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 wrote:
> 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, Microsoft MVP - Excel
http://www.andypope.info

"Andy Pope" <andy@andypope.info> ha scritto nel messaggio
news:%23xzuLlumGHA.4032@TK2MSFTNGP02.phx.gbl...
| 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...

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"bluepill" <bluepill@VELOCEwebnet.it> wrote in message
news:Qwyog.2002$yg6.1087@tornado.fastwebnet.it...
>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
>
>