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.
