China Naming Network - Ziwei Dou Shu - Display the temperature fluctuation chart of the last week in excel

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.