You can choose the one which suits the chart you created.Īnother option is to click your chart and look at your Excel menu bar. This will open another window where trendline types are available. This will show a drop down menu where you can find the option to Add a Trendline. If you use Office 2013, you can create a trendline to complement your reports by right clicking the data series (e.g., the information that has been graphed to charted) in the chart you created. This will enable the user to easily comprehend and analyze the message you are trying to imply. This can help reveal performance, value, and competitiveness of specific products and services, along with the relevant business departments, such as sales.īy knowing how to add a trendline to your presentation, you can create a graphical representation of the values you have computed. This helps foretell the possible path the values will take in the future. Trendlines allow businesses to see the difference in various points over a period of time. This is an important analysis tool which can help businesses understand not only where they are at right now but where they are heading in the future. By connecting points on a graph, trendlines can reveal upward and downward trends of a group of values identified in a presentation. For businesses to be able to spot trends when it comes to data on a graph, trendlines are able to connect the dots – literally.

How to add trend lines in excel 2016