To draw the trendline, select the sales and trend values (B1:C13) and make a line chart ( Insert tab > Charts group > Line or Area Chart).Īs the result, you have both the numeric values for the line of best fit returned by the formula and a visual representation of those values in a graph: To have it done, select the range C2:C13, type the below formula and press Ctrl + Shift + Enter to complete it: Based on this data, we want to determine the overall trend in the time series ignoring hills and valleys. In this example, we have the month numbers (independent x-values) in A2:A13 and sales numbers (dependent y-values) in B2:B13. Supposing you are analyzing some data for a sequential period of time and you want to spot a trend or pattern.
TREND formula for time series trend analysis in Excel Excel TREND formula examplesĪt first sight, the syntax of the TREND function might seem excessively complicated, but the following examples will make things a lot easier. Since the new values are returned as an array, you won't be able to edit or delete them individually.