Select Points on X,Y Series Chart for regression

[CEO76]

Hi Forumers,

I have a X,Y chart that which appears to have 3 interval with different slopes, they are representing for P10, P50 and P90. What I want to do is to code in VBA such that I can interact with the chart and select points that I want to perform regression. May be a retangular shape places over those points plotted on a chart and by clicking a mouse then the points underneath that rectangular will be selected.

Can someone give me some hints or approach to this problem

Thanks

CEO76

[Andy Pope]

You will need to code against the chart events in order to determine where in the chart you are selecting points from. This is not easy as you have to translate mouse xy position to xy data values.

It my be easier to locate points in your data sets by defining bounding area via cells. You can then construct a new data series based on relevant points.