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.
4.) Select Scatter Plot with the data points displayed only
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.
8.) Click Next
9.) Place your graph as a new sheet in your spreadsheet. Click next and you have created your graph.