The tutor shares quick, easy way to get a graph and equation from Excel, 2007 version.
- Let’s imagine your x data is in range a1:a10, your y-data, b1:b10.
- Select a1:b10, then click Insert, then the Scatter icon. Then, in the drop-down that appears, click the one that looks like a scatter plot. Hopefully you’ll see your chart.
- Now, from the toolbar across the top, click Layout. A Trendline icon should appear; click it. You’ll see some choices, along with a More Trendline Options choice. If you want to see the equation on the graph, you must select More Trendline Options.
- Select the type of equation you want. Then, near the bottom, notice a check-box: Display Equation on chart. You must check that to see the equation on the chart.
HTH:)
Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.