Thread: Charts

I have a column line chart to which I add data monthly and then have to manually update the "source data" to reflect the added data on chart. This is a rolling graph, which mean that I have to remove data for one month(from last year) and then include the new month's data. Is there any way on automating this process...like a macro or something, so once I add the data excel automatically removes one month of old data and make changes to include fresh data.

Eg Currently chart is based on data from A2:F2 and I add new data to cell G2. I need something which automatically update the source data to cell B2:G2.

Hi asaini,

You could build a separate source for your chart (eg. on sheet2) that looks up the range of interest based on the first date you set in A1. That way you'd just continue adding to your raw data as usual, then change the date in sheet2!A1 for the chart.

Cheers,

Here's an example:

Cheers,

Oops, too much clicky clicky.