As I was walking away from my desk after the 2nd rambling post, I
thought of something similar which would still protect the data -- just
hide that row (and, of course, set the appropriate option to only plot
visible cells).

Made me feel kinda stupid for making a mountain out of a molehill.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi Randall,

"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.

If you're comfortable with deleting the source data for that point, you
should be OK; Tushar's replies point out the problems if you want to
keep the source data intact, but just not display it on the chart.

Personally, I would respond to the point being clicked, rather than just
a mouse over. Clicking a point will fire the _Select event and Jon's
article shows how to respond to that. Furthermore, if you use defined
names to link your chart to your data, the code for the _Select event
could be as simple as:

Private Sub Chart_Select(ByVal ElementID As Long, _
ByVal Arg1 As Long, ByVal Arg2 As Long)

'Is a point selected?
If ElementID = xlSeries And Arg2 0 Then
Application.EnableEvents = False
Sheet1.Range("chtXData").Cells(Arg2).EntireRow.Del ete
Application.EnableEvents = True
End if

End Sub

which assumes there's only one series and the source data X values have
been given the defined name "chtXData".

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk