Firstly, you will need to download the Microsoft Excel application on your computer or laptop. Consider buying the office DVD from a proper computer software retailer. Install the product onto your computer. Installing can takes several minutes, therefore you are advised to be patient through the installation process.
Go to the main menu and open the Microsoft Excel program. Open a new file and on a fresh worksheet, consider entering all the x and y data values. The number should go downwards in a single column to accurately plot the graph.
Typically, Excel allows you to control the x values on the graph. For example in a relationship between the time spent in revisions and marks obtained, time spent in revisions will be the x data.
Enter the y data as a vertical series of numbers on the same worksheet. The values of y should be placed to the right of x column. Every y value must have a x pair to make the tool work on Excel. Now place the cursor on the left top of the data columns and hold down to drag the cursor to the bottom right of the columns. As you release the mouse button, you can see the entire data columns highlighted.
Now find the Insert tab on the Excel Menu. Find Charts and then choose Scatter. The program will generate a scatter plot graph for the data provided. Add a trend-line to determine the relationship between x and y values.