+ Reply to Thread
Results 1 to 2 of 2

Click on the label for the updating of a scatterplot

  1. #1
    Registered User
    Join Date
    03-10-2010
    Location
    Italy
    MS-Off Ver
    Excel 2003
    Posts
    12

    Click on the label for the updating of a scatterplot

    I use a macro that points to word´s libraries, that allows me to extract, given a word, some terms (synonyms and antonyms). Afterwards, using a button that refers to a Form, I plot the extracted data on a scatterplot. Up to here no problem!
    My need is to "do this research from the chart" by clicking on each label present on the scatterplot in order to update it.
    Let me explain better: after the click on a single label chosen from Sheet3 the procedure should:
    - Write to cell A2 of Sheet2 the name of the selected label
    - Recall the Sub m (), Sub mCopy (), Sub mColor ()
    in order to update the graph on Sheet3.
    To better explain my question I have attached the work file.
    Best regards
    Antonino
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Click on the label for the updating of a scatterplot

    You need to capture chart events. And then determine what exactly has been selected before processing the code you requrie.
    Here is a recent question on a similar topic, there are other on the forum.

    http://www.excelforum.com/excel-prog...-function.html
    Cheers
    Andy
    www.andypope.info

+ 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