The equation will be in the form of y mx b where m and b will be numbers. Right-click the existing graph and choose Select Data from the context menu. The slope of a line is calculated by plotting the data and using the.
In the Series name box type the desired name say Target line.
In the opening Format Trendline pane check the Polynomial option and adjust the order number in the Trendline Options section and then check the Display Equation on Chart option. Making slopegraph slope chart in Excel Step by step Step 1. When we have multiple xs and ys like most of the time. Section 14 Graphing functions with Excel.