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
Bookmarks