China Naming Network - Auspicious day query - Excel shows the recent temperature fluctuation of 1 week.
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.