What type of trendline you use is often determined by the type of data you're tracking. It's possible to add more than one trendline on a set of data to gain additional types of analysis. There are many types of Excel trendlines you can use for extended data analysis. Related: How To Calculate NPV in Excel Types of trendlines in Excel You can't add trendlines to 3-D charts, stacked charts, radar charts or pie charts. Trendlines are compatible for use in the following chart types: A trendline visually enhances a chart and makes the analysis process easier for any person to understand. Businesses use trendlines during data analysis to forecast future values and predict upcoming trends in particular data sets. Related: How To Make a Graph in Excel What is a trendline in Excel?Ī trendline is a line added to a data set to help illustrate the trend analysis in a series of data. In this article, we explore what a trendline is, types of trendlines available to you in Excel, why you extend trendlines in Excel and how to extend a trendline in Excel. Learning more about how to follow your data in Excel and use trendlines to forecast values can help you predict the performance of your teams and company. Management can use this data not only to monitor current performance but also to forecast future values. There are many ways that businesses may gain useful points of data, whether through performance metrics, sales data or warehousing systems.

How to add trend lines in excel 2016