Excel Graphing Help

 

1)      Open a new Excel spreadsheet

2)    Enter data in columns, information from column A will automatically be on the X-axis of your graph. (see figure below)

3)    Highlight data (all columns, NO WORDS OR LETTERS!, see figure below)

4)    Left click the chart icon on the tool bar (see figure below)

 

5)    Select XY (Scatter)

 

 

 

6)    Label your series by selecting the series tab. Select the series you wish to name and type to title in the box labeled “name”.

NOTE- Excel normally defaults to have the data range go by columns, if the numbers on your axes are switched (what was supposed to be on X is on Y and vice versa), on the “data range” tab of this screen, make sure the “columns” bubble is checked.

7)    Click next

8)    Properly name your graph (The Effect of X on Y) and axes, include units if applicable!

9)    You may choose to have your graph on the same page as your data, or you can create a new page for it.

10) Make sure your graph is using an appropriate scale. If you want to change the range or increments of your axis, right click on the axis and select “format axis”.

 

11)  Right click a data plot on your chart and select “add trendline”

12)  Select the type of line that best fits your data, try different ones to make sure.

              a) DO NOT USE MOVING AVERAGE LINE!

13)  Optional- format data points, trendlines and graph as you wish by right clicking and selecting “format data series” or “format trendline” or “format plot area”