Advice: Dynamic named range Discontinuous, Non-VBA

[byundt]

Here is a dynamic named range that returns every third point:

=INDEX(OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1),3*ROW(INDIRECT("1:" & INT(COUNTA(Sheet1!$A:$A)/3))),1)

While I could paste this formula to a worksheet using an array formula, I couldn't get it to work with a chart series.