Tip : When your chart is selected, customize the style and colors using the Design tab. You should be able to work with your line of best fit inserted into the chart.

Click the X in the top-right corner of the Format Trendline panel to exit it.You can fully customize how the line looks, allowing you to easily differentiate it from the rest of your chart. To customize how the line of best fit appears on the chart, switch to the Fill & Line and Effects tabs in the Format Trendline pane.This displays the math calculations used to create the best fit line. At the bottom of the Trendline Options section, ensure that the checkbox next to Display Equation on Chart is enabled.Here, look for the Trendline Options tab, and then select Linear from the available options. You should see a pane open on the right side of the window, called Format Trendline.Select the Add Trendline option from the context menu. Once the chart is inserted into your workbook, right-click on any of the data points.This is going to insert a Scatter chart into your document, using the data you previously highlighted. Select the first Scatter chart option, once again visible on the image below.In the Charts panel, click on the Insert Scatter (X, Y) or Bubble Chart icon as shown on the image below. Use the Ribbon interface and switch to the Insert tab.The selected data will be used to create a chart. Highlight the data you want to analyze with the line of best fit.Make sure there’s already data in the workbook. Open the Excel document you want to add the best fit line to.

The process requires you to create a chart first, and then add and customize the line to analyze your data correctly. In newer software versions, such as Excel 2019, the process of adding the best fit line to your charts is quite simple. Add a line of best fit trendline in Excel 2013 and up Fortunately, Microsoft Excel has a reliable method of finding and representing a trendline by doing the calculations for you.īest fit lines have many purposes and may help you significantly in visually representing your data. To make this line by hand, you'd have to use a complex formula. A line of best fit, also known as a trendline or best fit line, is a straight line used to represent a trending pattern in a scatter graph.

How to plot a graph in excel 2010