Menu
Related Articles
2011 (Mac): With the Conversion Rate series selected, choose Charts tab > Change Series Chart Type > Line > 2-D Line > Line. Then select the series again like you did before (it doesn’t stay.
- 1 Make a Line Plot in PowerPoint
- 2 Restore an iPad With a Hard Reset
- 3 Find the Slope of a Line on an Excel Graph
- 4 Find a DSL Modem's IP Address
Microsoft's Excel software for Mac can execute a number of statistical functions, including finding the y-intercept of the line formed by a set of data points. 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.
1.Click the cell in your spreadsheet in which you would like Excel to display the y-intercept of your line.
2.Type '=INTERCEPT(' without quotes in the formula bar above the spreadsheet.
3.Click the first cell containing the y values of the line that you need the intercept for. Hold 'Shift' and click the last cell containing the y values of the line.
4.Type a comma in the formula field. Click the first cell containing the x values of the line and then hold 'Shift' and click the last cell containing the x values of the line.
5.Type a closing parenthesis and press 'Enter.' The y-intercept of the line will appear in the cell.
References (2)
About the Author
David Weinberg began writing in 2005 at New College of Florida, composing articles on history and political science for publication within the school and for online circulation. Weinberg has been a professional outdoor educator for more than five years with experience throughout the United States.
Cite this Article
Choose Citation Style
Weinberg, David. 'How to Find the Y-Intercept of a Line of a Graph in Excel on a Mac.' Small Business - Chron.com, http://smallbusiness.chron.com/yintercept-line-graph-excel-mac-31867.html. Accessed 24 October 2019.
Weinberg, David. (n.d.). How to Find the Y-Intercept of a Line of a Graph in Excel on a Mac. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/yintercept-line-graph-excel-mac-31867.html
Weinberg, David. 'How to Find the Y-Intercept of a Line of a Graph in Excel on a Mac' accessed October 24, 2019. http://smallbusiness.chron.com/yintercept-line-graph-excel-mac-31867.html
Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.