|
Graphing
with excel 1.
Label
columns with data that you would like to graph 2.
Record
data under proper label 3.
Under Insert select insert
graph/chart 4.
When
window opens; select scatter point
graph, select next 5.
When
next window opens, select the tab Series 6.
Select
add a series, new window opens 7.
In
the box for Y series à highlight the data that you want to be graphed on that axis 8.
In
the box for X-series à highlight the data that you want to be graphed on that axis 9.
Press
the next button 10.
When
the new window opens (Chart Options) Name your chart, put in labels from x
and y axis 11.
When
finish press next button 12.
When
new window opens press the finish button, make sure the button to place in
current sheet is selected 13.
Under
Chart heading select Add
Trendline, select Linear 14. Click on options tab, click on box to Display Equation on Chart |