Creating Graphs in Excel

1.) Enter your data into the Excel database. Place the data you would like represented on the x-axis of your graph in column A, and the data for the y-axis in column B.

2.) Highlight all of your data (hold control to highlight a 2nd column).

3.) Click on the Chart Wizard (colorful 3-D chart at top) button.

clip_image004

4.) Select Scatter Plot with the data points displayed only

clip_image006

5.) Click Next and ensure that your graph appears to look correct.

6.) Click Next.

7.) Enter your chart title and axes labels including units.

clip_image008

8.) Click Next

9.) Place your graph as a new sheet in your spreadsheet. Click next and you have created your graph.

clip_image010