Share via

Draggable point on Excel plot

Anonymous
2017-04-14T10:57:03+00:00

I've been searching for a method to enable plotted points on a chart to be dragged with the mouse, so that the X/Y data in the chart source data gets updated. Apparently this functionality was available in Excel 2003, but was removed from 2007 onwards. I'm currently using Office 2010.

All hits seem to lead to this solution provided by MS; https://blogs.office.com/2009/11/02/excel-add-in-for-manipulating-points-on-charts-mpoc/ , but the VBA and Add-In solution pages linked to in the blog post appear to have been moved, and are no longer available (link and link).

Does anybody have the VBA code available for this, or know where the Add-In can be downloaded?

Many thanks in advance!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-04-26T12:19:46+00:00

    Andy: well done finding this - it is well hidden!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-04-25T22:27:32+00:00

    Taking my cue from Microsoft, I thought I'd check back and ask again if anyone has any helpful advice about this question? Any help gratefully appreciated.

    Cheers!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-04-14T14:55:07+00:00

    That's pretty much what I stated in the question Bernard, but thanks for your reply anyway.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-04-14T12:58:51+00:00

    It appears that Microsoft has remove the MPOC add-in

    If you go to https://blogs.office.com/2009/11/02/excel-add-in-for-manipulating-points-on-charts-mpoc/ and click the lick you get an error

    So we say farewell to MPOC...

    best wishes

    Was this answer helpful?

    0 comments