Make chart series rise when number of rows rise
The trick is to refer to your Value set by name rather than cell-address-range. Example procedure, starting from your example chart:


Ensure Table 1 row 1 is a Header Row
Put a cosmetic name in B1, naming your column B series, say… Series
Change the Chart's Data Value field from a cell reference to the new column header name, e.g. Table 1::Series


Since the chart is now set to simply reflect all of that column's data, it will update live as new data appears.