From this window, click the 3rd icon (when hovering your mouse, you will see its name is Trendline Options).A window named Format Trendline will appear.After that, select the Trendline option and click on the angle icon ( 〉) just beside it.Then unmark the Gridlines for a better view.Click on the Chart Elements button (a + sign you see in the image below).You are done with making the graph, a couple more steps to get the result now.Notice that the Calculate x-Intercept (the name we gave) series appears and is selected automatically.Now we will be back to the Select Data Source window again.Note that, like the previous method, Excel’s X values are equivalent to our Y values here. From this window, give a suitable name for the series.From the Select Data Source window, press the Add button.Now, click on the Chart Area canvas and then right-click on your mouse.First off, go to the Insert tab and click on the Scatter icon and select the first suggested icon.You can also find the x-intercept by using the Trendline Equation feature of the Excel graph created from the dataset you have. Using the Trendline Equation Feature of Excel Graph Read More: How to Show Intersection Point in Excel Graph (3 Effective Ways)Ģ. Or, when the covid cases tend to zero, the use of masks among people is still 90.16%.So, this result means: when the use of masks is 90.16%, the covid cases will be zero.

x-Intercept means the y value is set to zero.

How to find trendline equation in excel