title: Updating excel charts automatically each month with new data and rolling the last month off the end
body: <p>I have been given a set of historic data that requires line charting for the given range (say 12 months). We insert a new column at "B" each new month so the historic data moves along one column.</p>
  
  <p>Can we automatically update the chart with the new months data and roll off the previous last month from the chart when we insert the new data?</p>
  
  <p>We can change format the data to suit a solution ie possibly inserting a new column isn't the best way to add data, for the most part the the whole dashboard type solution is legacy - your thoughts appreciated</p>
  
  <p>Tony B </p>