Excel's intercept function takes the data points that define a line on a graph and calculates the y value for the point on the graph where x is equal to zero.

The values are plotted across the y-axis and the x-axis is used to mark the progression. In the case of a scatter plot, whether you use it simply with marking points or lines, the graph is spread ...

How to Find the Slope of a Line on an Excel Graph. In math and statistics, you may occasionally need to calculate the slope of a line generated by coordinates in the (x,y) format.

There's a lot going on in these formulaic conditional rules in Microsoft Excel that highlight the smallest and largest values within a period of years.