View Single Post
  #5   Report Post  
 
Posts: n/a
Default

Thanks Tushar.

"Exclude" in this context means to remove the point from the data
series and redraw the charts. We are attempting to deal with errant
points that are annomalies in our data series. The series includes
serveral hundred/thousand points which originate in an engineering
application and are used to produce approx 700 charts. Because of the
volume, our Engineers would prefer to visually remove the points in
question rather than wade through the data series.

Jon's suggestion works in that it allows me to intercept the event.
However, I am exactly in the state you predicted and with my limited
Excel VBA experience, I am beginning to wonder if Excel is the right
tool or to your point, is this a project that requires a experienced
"commercial" developer.
Any thoughts would be greatly appreciated.

Best Regards
R. Hiltz