Menu
Related Articles
Line charts are useful for showcasing trends over time, while they may look similar in some ways to x-y scatter plots, the main difference with line charts is that the horizontal axis is an equally spaced category axis. Adding Data Labels to bar graphs is simple. Click Design under Chart Tools and then press the drop-down arrow next to Add Chart Element. You can also hover over your chart until three icons appear next to the right border of the graph. Choose + to add chart elements. Click the check box next to Data Labels.
- 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 22 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 22, 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.
Linear relationships abound. Ten customers in your store will buy roughly twice as much as five customers. A service call five miles away will take about five times as much gasoline as a call one mile away. Staying open for three night-time hours will cost about three times as much in electricity as staying open for one night-time hour. All of those relationships can be described with linear equations. One of the most common and convenient forms of a linear equation is y = m*x +b, where m is the slope of the line and b is the y-intercept. If you've got data, but aren't sure how to put it in that linear form, Excel for the Mac can help.
![Excel For Mac Line Graph Excel For Mac Line Graph](http://asmex.club/wp-content/uploads/2017/12/how-to-make-a-bar-graph-in-excel-mac-make-a-line-chart-in-excel-image-titled-make-a-line-graph-in-excel-step-3.jpg)
Analytical Solution
Step 1
Open a new spreadsheet and type 'X' into cell A1 and 'Y' into cell A2.
Step 2
Enter your x values into column A starting in cell A2. Enter the corresponding y values into column B, starting in cell B2. Remember that each x value will have a corresponding y value matched to just that value.
Step 3
Select all the x-values, from cell A2 down the column to the end of the x values you've just entered in. Choose 'Insert,' 'Name' and then 'Define' from the menu bar. The dialogue box will come up with 'X', which you had entered above the data. Accept that name by clicking 'OK,' which will let you refer to all your x values using just the name 'X'.
Step 4
Repeat Step 3 for the y values in column B, except the B column dialogue box will offer you the name 'Y,' which you should accept.
Now 'X' and 'Y' refer to the data you've entered for x and y values.
![Line Line](/uploads/1/2/5/6/125699729/100476077.jpg)
Step 5
Click in cell D2 and type '=Intercept(Y,X)' without quotes. The value Excel computes will be the y-intercept.
Step 1
Select the cells containing the x and y values.
Step 2
Select the Charts toolbar, select the 'Scatter' option and then select the 'Marked Scatter' option. A graph will appear with the x and y values shown as points.
Step 3
On the toolbar for Excel for Mac, select 'Layout 9' from the 'Quick Chart Layouts' option. This will draw a 'best fit' line through the data points. It will also write an equation on top of the graph.
Step 4
Extract the y-intercept value from the equation displayed on the graph. The equation will be in the form 'y = m*x +b' where m is a number corresponding to the slope and b is a number corresponding to the y-intercept.
Tip
- Remember, you type an equals sign as the first character in a cell where you want to enter a formula.
- You can also have Excel compute the slope analytically as well; just type '=slope(Y,X)' in whichever cell you'd like to have display the slope of the line that best fits your data.
References
Resources
Photo Credits
- Comstock Images/Comstock/Getty Images