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

**shamedt** · 02-17-2011, 10:45 PM

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,

**Andy Pope** · 02-18-2011, 05:30 AM

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.

**shamedt** · 02-18-2011, 03:01 PM

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.

**Andy Pope** · 02-19-2011, 07:46 AM

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

**shamedt** · 07-08-2011, 02:16 PM

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?)