<\/figure>\n\n\n\nThe following scatter graph is inserted into the worksheet:<\/p>\n\n\n\n <\/figure>\n\n\n\nStep #2: Add a Trendline to the Chart<\/h2>\n\n\n\n On a chart, a trendline depicts the overall direction or pattern of the data. It’s useful for visually assessing and forecasting trends in the data.<\/p>\n\n\n\n
We use the following steps to add a trendline to the chart we created in Step #1:<\/p>\n\n\n\n
\nTo open the Format Trendline<\/strong> task pane, select the graph, click the Chart Elements<\/strong> button with a plus sign icon on the top left corner of the chart, click the right arrow on the Trendline<\/strong> option, and select More Options<\/strong> on the flyout menu:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nAlternatively, you can open the Format Trendline<\/strong> task pane by selecting the Trendline<\/strong> option checkbox, right-clicking the trendline, and choosing Format Trendline<\/strong> on the context menu:<\/p>\n\n\n\n <\/figure>\n\n\n\nThe Format Trendline<\/strong> task pane is displayed on the right of the Excel window:<\/p>\n\n\n\n <\/figure>\n\n\n\n\nOn the Format Trendline<\/strong> task pane, choose the type of trendline you want, for example, Linear<\/strong> or Exponential<\/strong>. In this case, we go with Linear<\/strong>, the default option.<\/li>\n<\/ol>\n\n\n\nStep #3: Display Equation on the Chart<\/h2>\n\n\n\n To display an equation on the chart, use the step below:<\/p>\n\n\n\n
Select the Display Equation on chart<\/strong> option at the bottom of the Format Trendline<\/strong> task pane:<\/p>\n\n\n\n <\/figure>\n\n\n\nThe equation is displayed on the graph shown below:<\/p>\n\n\n\n <\/figure>\n\n\n\nNote:<\/strong> The equation generated will depend on the type of trendline selected. In this instance, a linear equation was obtained as we chose a linear trendline.<\/p>\n\n\n\nConclusion<\/h2>\n\n\n\n This tutorial showed the steps needed to display an equation on a chart in Excel. We hope you found the tutorial helpful.<\/p>\n","protected":false},"excerpt":{"rendered":"
Sometimes you may need to display an equation on a chart in Excel. For instance, displaying the forecasting equation on the chart can…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Display the Equation on a Chart in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n