Automatically updating graphs

Hi all, hoping you could help me out with a problem I’ve been trying to solve.

I have a line graph in a one-pager which needs to be updated every month. Currently, all my other exhibits are set up so that I simply change a cell value to the most recent month-end date and all the values/graphs update to display the relevant information.

The data that the graph pulls from looks like this:

What I currently do is simply drag down the formulas one row in order to update the graph. However, I was hoping for some way to have that be done automatically by me simply changing the date in a cell. Eg, changing the date from 8/31/2017 to 9/30/2017 and having the data automatically pull down one more row. Is this sort of thing possible?

 

Any help would be much appreciated.

By: Daniel

Leave a Reply

Your email address will not be published. Required fields are marked *