I'm trying to automate updating a number of dynamic charts in an
excel spreadsheet. I've created a userform which prompts the user to
input 4 values (including a date), and then inputs the data into a new
line on a sheet. What I now need to do is write code which gets each
chart to include the new line of data, and to exclude the first line.
For example, the charts currently look at the range A4:A16, but when
the new data is added to row 17 I want the charts to plot A5:A17 (and
so on each month).

I've tried using the OFFSET and SERIES functions, but this only seems
to let me add a new line in to the chart source data while retaining
all the rest.

Please help! I hope I've explained this problem clearly.