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.