I need to recreate a graph in Excel but don't know how to get started. I know how to make graphs in Excel, that's not the problem, I just don't know how to do this one. I can see the what this one is supposed to look like, and from the answers, there are two points, (50, 0) and (0, -200).
How would I get started to graph that line?
Oh, and I know the slope of the line is 4
well, y = m x + b
when x = 0, y = -200
so
y = 4 x - 200
Yes, anonymous, I know the equation, I just am not sure how to graph in Excel
https://www.workzone.com/blog/how-to-make-a-graph-in-excel/
Maybe that will help
Since it is a line I suspect you need only put the two points in, but I have never used it.
To graph a line in Excel, you will need to create a scatter plot. Scatter plots are useful for showing the relationship between two numerical variables. In this case, you have two points, (50, 0) and (0, -200), which represent the x and y coordinates.
Here are the steps to get started:
1. Open Excel and enter your data. In this case, you can create a table with two columns: one for the x-values and one for the y-values. Label the columns as "x" and "y".
| A | B |
---|---|---|
1 | x | y |
2 | 50 | 0 |
3 | 0 | -200 |
2. Select the data range (including the column headers) by clicking and dragging from A1 to B3.
3. Go to the "Insert" tab and click on the "Scatter" chart type. Choose the first scatter chart option (usually labeled as "Scatter with Straight Lines").
4. Excel will generate a scatter plot with the data points connected by straight lines. Adjust the chart's appearance as desired, including the axis labels, title, and gridlines, by using the design and formatting options available in Excel.
That's it! You have now created a scatter plot in Excel, representing the line between the points (50, 0) and (0, -200).