The tutor shares quick, easy way to get a graph and equation from Excel, 2007 version.

1. Let’s imagine your x data is in range a1:a10, your y-data, b1:b10.
2. 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.
3. 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.
4. 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.