Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
copy graphs values in a cell
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
copy graphs values in a cell
"Andy Pope" 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... :) |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
copy graphs values in a cell
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |