Deleting a point from a scatter plot

[David El-Taher]

Good morning, everyone.

I am hoping someone might be able to point me in the right direction. I routinely need to create scatter plots and need to develop the equations for curve fitting those plots. The data points are experimentally collected and written automatically to a comma delimited file from which I import the data.

I am trying to find a way to be able to choose a particular point on the scatter plot out of all the other points to delete(for example, if a point was clearly an outlier point and its presence would significantly throw off the curve fit). I envision creating a macro, say, "Delete Points", which, upon activating, would enable me to put my mouse pointer over the desired point and when I press the left mouse button, the point would be "selected" changing color. When I would press the right mouse button, all "selected" points would be deleted from the scatter plot data range.

Any ideas?

P.S. If you feel that this is flatout impossible for excel, do you know of a software that creates such interactive plots?

Thanks!!

David
david.el-taher@navy.mil