I have an excel sheet that is made up of data that changes year to year. One of my graphs spans a period of 4 years and changes based on the current Grad year to four years later [2014-2017]. The other begins from a set year and includes data up to the current Grad year [2012-2017]. I would like these graphs to change automatically when data is inputted.

Is this possible? This is what I desire: in theory, when I input new data in the data tab next fall, the graphs will automatically change based on the new inputs. New data ranges would include: [2015-2018] and [2012-1018].

If you have further questions after looking over the excel file, let me know. Thanks for any help you have for me!

Demographics.xlsx