Create chart on Home Page using data from Different sheet

Hi All,

I have a workbook that has two sheets currently in use. Tab "India", "Monthly_spends". Now I wish to have a scroll bar chart on home page based on country selected from the data validation list. The chart should show 3 months at a time, for e.g for jan, feb, mar...then apr, may, jun....then jul, aug,sep...then oct, nov, dec.

The chart should be selected for the country selected from the list. Currently data is for Region LATAM for the countries Mexico and Brazil. Help shall be highly appreciated.Please find the attached sheet for reference.

Thanks in advance!