I have a large data set that automatically updates with the most current numbers over a three year time period.

Here’s a simple sample workbook:
excel example.xlsx

Now I need to have dynamic graphs where I can choose, which time periods are plotted to the chart. So ideally I would have a cell where I write the time period until what time period the graph will be plotted and another cell where to write how many time periods backwards will be plotted.

This is what I found that's closest to what I need:
http://www.gilliganondata.com/index....your-charts-2/
The problem is that I don't want to make new data charts + I had hard time to get my head around how those named ranges work in my case..

Thanks,

Jaakko