Chart Range update every month

Hi Everyone,

I have a question. I am frustrated by this. I am trying to find a way to update the ranges of my charts automatically to a new column of data. For example, if you consult the excel sheet, I would like the sheet to be able to automatically update each month with the number of fruits for that particular month.
It would be even better if I am able to go back an forth eith the ranges as well.. like for example a dropdown or something like that for every month. so that I can download which ever statistic i want any time.
I want to be able to do this for more than 10 years. Would that be possible?

Cheers.