Can I have a chart pickup range of data in a column where it starts with a predetermined cell and ends with a "dynamic" cell–last one in the column that holds a value?
Every time I supplement data to my column I have to change chart data source to reflect the newly added rows. I'd like the chart to pick the end of data automatically.

I found this VBA... not sure if I can plug it in this instance
Sub LastRowWithData_xlUp_1()

Dim lastRow As Long

lastRow = ActiveSheet.Cells(Rows.Count, "B").End(xlUp).Row

MsgBox lastRow

End Sub