+ Reply to Thread
Results 1 to 4 of 4

copy graphs values in a cell

  1. #1
    bluepill
    Guest

    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. #2
    Andy Pope
    Guest

    Re: 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. #3
    bluepill
    Guest

    Re: copy graphs values in a cell


    "Andy Pope" <[email protected]> ha scritto nel messaggio
    news:%[email protected]...
    | 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. #4
    Bernard Liengme
    Guest

    Re: 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" <[email protected]> wrote in message
    news:[email protected]...
    >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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1