Chart only part of a table

[Yamezz]

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?

 

[NdNoviceHlp]

Hi Yamezz. You can use the same chart and adjust your data range. See Jon Peltier's code at this link. HTH. Dave

Macro to move chart data series reference down one row for all charts and all series in workbook.

Hi guys I have a number of line charts, some with one series some with multiple. There are around 70 of these charts which plot a variable over the past year from table on another worksheet. The table has months down the columns with a value for each location of the variable. See attached. Just...

www.mrexcel.com