I have a two-column named table showing date in column A against a number in column B. From this table I have a scatter plot chart. Given the data is in a table, as new entries are made, both the table and the chart update accordingly. However, for the majority of the data, the number charted hovers around the 1,000,000 mark, plus or minus 200,000. Later data is in the order of 20,000, plus or minus 5,000. The current chart loses its detail when charting later data. I would like to keep my original chart, but also have a second chart of later data (where the numbers are much smaller) that also updates automatically. Is there a way to dynamically reference the table from row 46 onward to produce the second chart?