How to dynamic chart a rolling three years (each year as separate line onf graph)

rolling three year example.xlsx

I wonder if someone could help with a bit of chart automation, which is beyond me, but I’m sure will be simple for people on this forum.

If you look at the spreadsheet, it’s an example of what I’m trying to do. I have a series of data, which is displayed in a graph as three separate lines, each representing a year.

What I’m looking to do is get the chart to automatically update when the next month’s data is added, so that the graph shows a rolling three years (each year in a separate line on the graph).

I hope someone is able to help. Thanks

Thanks very much for your feedback. I'll try out each method and let you know how I get on. Much appreciated.