In the ribbon, switch on the now visible Format tab.Click anywhere inside your chart that contains a trendline.Select any data series options you want, and click OK once you’re happy with the configuration. The Add Trendline dialog box will show up.Note that Excel only displays the Trendline option if you select a chart that has more than one data series without selecting a data series. After selecting your chart, click on the + (plus) icon to the top right of the chart.For trend lines specifically, we recommend using any of the 2D charts. Click on the Insert tab in your ribbon header interface.Make sure to select headers as well to ensure that appropriate labels are created for your chart. Select the cells that contain your data.If you don’t have a chart yet, follow these instructions to create one: Select the chart you want to add a trendline to.Use the following guidelines to add a trendline in Excel for Windows Insert a trendline in Excel for Windows In older versions of the application, some steps may be slightly different. Please note that our instructions were written for Excel 2013 and newer.

Get averages, notice peaks, and drops to make better decisions in the future, or even predict what could happen based on your current data. These graphics are built into Excel, and all you have to do is follow our simple and quick tutorial to get them in your projects.Ī trendline is a useful chart element that allows you to get more insight into your data at a simple glance.

Have you ever wanted to show data trends in your worksheet as a visual element? You can easily implement this in your Excel sheets with the use of trendlines.

How to add data to a chart in excel mac