Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Oct 2015
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Interactive scatter chart with mouse

    I have reason to make a scatter chart of X,Y coordinates represented by a marker (no line connection between points). There could be some variable number, eg 500, or 1000, or 5000 or more coordinates. They will normally be in some pattern, eg a regular grid, or in concentric circles. I can make the X,Y coordinates by importing them from another software or by using a formula. Now here's what I want to do. I would like to use the mouse to:
    1) click on an existing X,Y point (marker) and delete it (and have the corresponding cell values deleted)
    2) click on the chart where there isn't a marker and add a marker (with the corresponding cells being filled with the X and Y values).

    Is this doable in VBA? What sort of function names should I be looking at? The mouse pointer would have to show the X,Y values as it moves around the blank space on the scatter chart.

    Thanks,

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts
    Hi

    Welcome to the Lounge!

    ..before we can help you, is this for
    a) eye test exams
    b) game
    c) banking financials tracking
    d) military application

    zeddy

  3. #3
    New Lounger
    Join Date
    Oct 2015
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by zeddy View Post
    Hi

    Welcome to the Lounge!

    ..before we can help you, is this for
    a) eye test exams
    b) game
    c) banking financials tracking
    d) military application

    zeddy
    Hi,

    None of the above actually. I have made an X,Y scatter chart showing planned source positions for a seismic survey (basically a vibrating weight that injects a sound wave into the ground) and would like to be able to use the mouse to easily modify or delete some individual X,Y source coordinates to take account of certain on-site obstacles (eg pipelines, infrastructure).

    Hope that helps set the scene a bit.
    D

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts
    Hi D

    ..OK, gottit. Do you need any of my polar-logarithmic plotting chart paper?
    I've got frackin' loads of it. had it custom-made ages ago.

    I'm sure we can do something for you with vba.
    But, as always, it is much easier for us if the requester posts a sample datafile. Any typical data would do.
    saves us a lot of effort trying to create an appropriate sample.

    zeddy

  5. #5
    New Lounger
    Join Date
    Oct 2015
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Interactive scatter chart with mouse

    Hi Zeddy,

    I've attached a scatter graph of X,Y data. So ideally I would like to use the mouse on the chart (being able to zoom in would be nice) to add/delete X,Y points.

    Don't get rid of the polar log graph paper just yet - that will be plan B.

    Thanks,
    D
    Attached Files Attached Files

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts
    Hi D

    Many thanks for the sample file. This makes it so much easier to help.

    1. Now, when I move my mouse over the chart, my 'mouse-resolution-xy' is so much higher - I assume I can 'restrict' this to increments of 0.1 then (as per the displayed resolution)???
    2. Can we assume there are no 'overlaid' points??

    zeddy

  7. #7
    New Lounger
    Join Date
    Oct 2015
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Zeddy,

    1) Yes, working in increments of 0.1 is fine.
    2) And also there won't be any overlaid points.

    Many Thanks,
    D

Tags for this Thread

Posting Permissions

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