So we get the line chart graph as given below where it shows very clearly sales data month wise. To view in graphical chart format, choose insert and select the line chart format. We are going to using the trend function here to get the result, select the column D41 to D56 and use the trend function as per below.Īfter selection, we use the Trend function by selecting C41: C56 and then we have to use CTRL+SHIFT ENTER to get the entire trend value shown below.

The below example shows months wise sales data where there are ups and downs in sales value if we produce this format, we cannot view the sales data easily hence we can show the sales data in using trend function in chart format so that I will be given the appropriate result.ī40 represents Month, C40 represents actual sales, and D40 represents Trend values in the sales data. Let’s see another example with a graphical chart format using multiple values. So we have predicted the upcoming sales value for the next three months. Here the Trend function with the next month sales has been shown below. In this example, we have month wise sales data from Jan-18 to Sep-18 where we need to find the next month sales by using the TREND Function in Excel.

You can download this TREND Function Excel Template here – TREND Function Excel Template Example #1

TEXT and String Functions in Excel (26+).

Lookup and Reference Functions in Excel (36+).

How to add trend lines in excel 2016