How to create dynamic chart range based on an offset of the users selection

This question is built upon another question posed as found at:  
https://www.experts-exchange.com/questions/26645928/How-to-create-Excel-dynamic-chart-data-range-based-on-named-range-typed-into-cell-A1.html

The attached workbook is setup to change the data selection of a chart based on the users selection from a data validation list in cell A1.  the names in the data validation list are also named ranges referring to the chart data.

Challenge:   Due to the values of the month changing each month, to have the named range based on the month names creates high maintenance.. in the actual worksheet there are over 100 named ranges based on months and territories.  It would be too cumbersome to change the cells each named range refers to each time we want to run the report.

Is there a way, in the attached workbook, for example, where in cell A1, the user can select the month "Jun_10", then the chart selects the data based on the name found in cell D1? called Mth_01, instead of having to select the data from the range called Jun_10.

To gain a full understanding, it is best to read the first question referenced in the link above.

Thank you!


In addition, in the following reporting month, the six month report range would be Jul to Dec, instead of Jun to Nov.  But the first month of the data range would always be in the same position, column D.  The next month when the user selects Jul_10 as the data range to view in the chart, it needs to pull data in the first column based upon a named range titled Mth_01.. thus by having the named range from which the chart data is selected, be the same name and same cell range consistently (Mth_01 instead of Jun_10 or Jul_10), we would not have to change them each month.   I hope this makes sense.   Appreciate anyone up to the challenge!
 dynamic-chart-with-range-name-as.xls