graph from every nth cell

[Arie Bos]

I would like create a graph from every 4th cell in a column, e.g. B4, B8, B12, B16 etcis there a way to do this?Thank you, Excelleers

 

[veryamusing]

If you set the chart series to the named range ("=Sheet1!Data"), then along with the code below, every fourth value you add to one column will be added to below the last value in a helper column and the named range will be extended to include the added value.

Private Sub Worksheet_Change(ByVal Target As Range)
    With Target
        If .Column = 2 And .Row Mod 4 = 0 Then
            Cells(.Parent.Cells(.Parent.Rows.Count, "C").End(xlUp).Row + 1, "C").Value2 = .Value2
            ThisWorkbook.Worksheets("Sheet1").Names("Data").RefersTo = Range(Cells(2, 3), Cells(.Parent.Cells(.Parent.Rows.Count, "C").End(xlUp).Row, 3))
        End If
    End With
End Sub

Haven't considered adding more than one value at a time, nor deleting cells... But this should be a good start, and will give you something to work from. I'd be surprised if the gurus here don't come up with a better subroutine or a more elegant formula-based solution.

Good luck!