+ Reply to Thread
Results 1 to 5 of 5

Chart - finding the position of the line on a scatter plot

  1. #1
    Registered User
    Join Date
    02-17-2011
    Location
    Calgary, Canada
    MS-Off Ver
    Excel 2010
    Posts
    16

    Chart - finding the position of the line on a scatter plot

    Hello,
    I have plotted my data in a scatter plot. I have also added a Circle to this plot (which is movable). The user needs to move this Circle. Does anybody have any idea about writing a Macro which is able to report the position of this Circle after each movement?

    Thanks,

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

    Re: Chart - finding the position of the line on a scatter plot

    Can you use a separate data series for the circle and allow the user to move it via form controls? That way you would know the xy value for the circle center.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-17-2011
    Location
    Calgary, Canada
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Chart - finding the position of the line on a scatter plot

    This might be correct, but I am looking for a way that the user drag and drop and move the circle without any form controls. just click on the circle and move it, and after each movement the position would be reported. Thanks for your suggestion.

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

    Re: Chart - finding the position of the line on a scatter plot

    Shapes do not have events, other than the click one create by assigning a macro, so you can not detect that the user has drag/dropped the circle.

    ActiveX controls do have such events BUT you can not place an activex control within a chart or chartobject.

    So you first obstacle is knowing when to run code as you can not capture events relating to circle.
    You maybe able to detect change in the selection of chart elements and use that as a trigger to run code related to circle.

    The next obstacle is relating the circles position in relation to the data in the chart. The distance units used by the shape and chart means it is not simple to convert circle left/top properties to xy value within chart.

    You may find this article helpful
    http://blogs.office.com/b/microsoft-...arts-mpoc.aspx

  5. #5
    Registered User
    Join Date
    02-17-2011
    Location
    Calgary, Canada
    MS-Off Ver
    Excel 2010
    Posts
    16

    Tertiary and more vertical axis in Excel

    Hello,
    I wonder if I am able to add tertiary or more vertical axis to scatter plot. I found (http://peltiertech.com/Excel/Charts/TertiaryAxis.html) but it was not helpful as the procedure for the first plot is not explained there. Any help would be much appreciated,
    Thanks! (SORRY! I CANNOT DELETE THIS. I THOUGHT THIS WILL BE A NEW THREAD. COULD YOU DELETE THIS?)
    Last edited by shamedt; 07-08-2011 at 02:25 PM.

+ 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