I have a large number of charts whose underlying data is updated weekly. A typical series looks like this:
Each week I add another row of data and update the series accordingly:
The problem is that I have to manually update the series in dozens of charts each week. How can I have my charts dynamically update their series values, perhaps by referencing a single cell or cells that I can change in one place?