Rolling 12 month column chart

Luka

I have a column chart as seen below:

The summary sheet i use as the data source is formatted as below:

I used a summary sheet instead of a summary report as it gives me more options to manipulate the data, but also structure it correctly in terms of month order.

The months and years will have to manually be inputted and the formulas in the final 3 columns will have to be dragged down. However, is there a way to automate the chart widget/ summary sheet so that it is only the final 12 months in the summary sheet that get included in the dashboard widget, or will this have to manually be selected each month?

Thank you in advance.