Area Select Tool
 

Hi, I created a charting tool that sets symbol size, shape, and color
depending on characteristics of the source data. The chart itself is a
standard Excel chart (x-y scatter). I've also implemented chart event
trapping when a user clicks on the plot area or on a specific symbol
(courtesy of a previous request on this forum thank you).
I'm interested in any advice for how to implement an area selection
tool. I would like a user to select a rectangular area of the chart. I'd
like to know (after the selection is completed) the coordinates of the
selected area in relation to the x and y scale of the chart. Knowing these
coordinates, I'd run some code which does some stuff applicable to which ever
chart datapoints fell inside the selected area.

Thanks much.