Display the temperature fluctuation chart of the last week in excel

You need to insert an offset definition, similar to

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

This way, how to write the formula depends on the specific format of your table (for example, is there a title row?)

Define this formula as a name, and use this name for the SERIES in the table sequence.