I have a worksheet which has a column of numbers which must be charted using
a line chart. Currently the column has 48 rows, but additional rows will be
added as more data becomes available.

Is there any way (maybe using VBA) go get the chart to update the data
series by add each new number added to the column?

I do not want to include a number of empty rows because that would eave the
right side of the chart empty.