FIND Y=MX+B ON EXCEL HOW TO FIND THE

Find Y=Mx+B On Excel How To Find The

Plus, get 1 TB of cloud storage, document sharing, ransomware recovery, and more with OneDrive. Create your best work with the latest versions of Word, Excel, and other Office apps. Solution: We know that the slope-intercept form of a line is y mx + b.Get more done with Microsoft 365. Example 2: Find the slope-intercept form of a line with slope -2 and which passes through the point (-1.4). It explains how to find the slope and y intercept o.In Select Data chart option we can change axis values or switch x and y axis If we want to edit axis or change the scaling in the graph we should go to Format Axis options.Applying, m 2 and b 1 in the equation of the line(y mx + b), we get y 2x + 1 Thus the equation of the straight line is y 2x + 1.

As a result, we changed x axis values from Years to StoresFigure 5. Select the Edit button and in the Axis label range select the range in the Store column: Select Data on the chart to change axis values Right-click on the graph and choose Select Data:Figure 2. Learn programming, marketing, data science and more.In the example we have a chart with Years on x-axis and Sales values on the y-axis:To change x axis values to вЂњ StoreвЂќ we should follow several steps:

As a result, we changed the y axis values:Figure 9. Select the Edit button in the Legend Entries (Series) and in the Series values select the range from the bottom Sales column: Select Data on the chart to change y axis values

How to change the scale How to Switch X and Y AxisAnother interesting chart feature that we will learn is how to switch x and y axis. Format axis for Minimum insert 15,000, for Maximum 55,000As a result, the change in scaling looks like the below figure:Figure 10. Under Axis Options, we can choose minimum and maximum scale and scale units measure Select the axis that we want to edit by left-clicking on the axis In our example, we will change the minimum scale to 15,000 and maximum scale to 55,000 on the vertical axis.If we want to change the axis scale we should:

We guarantee a connection within 30 seconds and a customized solution within 20 minutes. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. How to edit x axis Instant Connection to an Excel ExpertMost of the time, the problem you will need to solve will be more complex than a simple application of a formula or function.

Find Y=Mx+B On Excel For Mac