Excel shows the recent temperature fluctuation of 1 week.

You need to insert an offset definition, similar to.

=OFFSET($A$ 1，COUNTA($A:$A)-7，，7，)

How to write this formula depends on the specific format of your table (for example, is there a header row? )

Define this formula as the name, which will be used by the series in the table sequence.