Hello,

in my code, every chart datapoint with a value 0
is assigned the markerbackgroundcolorindex 3 (red).

If however, one datapoint in the list has no value (#NV),
the vba loop can't select it, consequently the code stops.

How can I possibly trap that case and make the loop

.....
For i = 1 to 10
ActiveChart.SeriesCollection(1).Points(i).Select
With Selection
.Markerbackgroundcolorindex = 3
End with
....

continue correctly ?

Thank you in advance.

Kind regards,

H.G. Lamy