Change chart range (number of periods to include) based on cell value

[Calita]

I have a number of dates running horizontally from the earliest on the left to the latest on the right. I would like to create a dynamic range in which I can specify a number (for example, three) and the chart adjusts to only display the latest three periods.

How can I go about this?

Thanks!