Depending on the number of periods set, this option gathers the values together and computes its average which is then used as the trend point. This levels out the extreme fluctuations for easier trend analysis.
Trend lines in excel 2016 series#
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.
Trend lines in excel 2016 how to#
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.