Adding a Trendline in Excel: A Step-by-Step Tutorial

A step-by-step tutorial for adding statistical trendlines to Excel charts, perfect for data visualization and analysis.

1 min readExcel Guide

How to Add Trendlines to Charts in Excel for Better Data Insights

In this article, we'll walk through the process of incorporating trendlines into your Excel charts, making your data analysis more insightful and professional.

  1. Activate Your Chart: Begin by clicking on the chart where you'd like to incorporate a trendline.
Excel column chart titled Sales showing monthly sales from January to June, selected before adding a trendline.
  1. Navigate to Design Options: After selecting your chart, locate the Chart Design ribbon at the top of your screen. Windows users will notice a plus icon (+) in the chart's upper right corner.
Excel Chart Elements menu open beside a sales chart, with the Trendline submenu listing Linear, Exponential and more.
  1. Access Chart Elements: Mac users should locate and click "Add Chart Element." Windows users can access trendline options directly through the plus icon menu.
  2. Choose Trendline Option: From the dropdown menu, find and select the trendline feature. This will reveal various trendline styles available for your chart.
Excel sales column chart with Trendline checked in Chart Elements and dotted trendlines added across the bars.
  1. Pick Your Trendline Style: Browse through the available trendline options and select the one that best fits your data analysis needs. For additional customization, select "More Trendline Options" to access the "Format Trendline" sidebar, which offers a comprehensive list of trendline settings. Simply check the box next to your preferred trendline style to apply it.
Excel Format Trendline pane with Linear selected under Trendline Options, next to the sales chart and its trendline.

You have now successfully added a trendline to your chart.

Let’s make AP
work for you.