Dynamically updating charts in Excel
Posted on 2011-02-22
I have some graphs in excel which I update on a weekly and monthly basis.
Everytime I add a new data point, how can I have the chart automatically update so that it only shows the last e.g. 10-data point rolling period?
I have 12 monthly stock prices, one price each month. Now that we are in Feb, I might want the chart to show Feb 2010 to Feb 2010 after I have added a new column in the worksheet.
At present, I have to right click on the chart, select Source Data and then incrementally increase the the cell referencing values by one letter (column) to reflect the rolling period.
How can this be done automatically somehow?