How to Plot a Graph on Microsoft Excel

Microsoft Excel allows you to track data by inputting the data into cells. Once you input data, Microsoft Excel can graph the data into a multitude of graphs. If you want to just plot a graph, use a scatter plot. This will place the dots for each data set you have on a graph. Your data set will need coordinates for the X-axis and the Y-axis. This is important because it shows data in a visual manner, instead of in a numeric manner.

...
Excel eliminates the need for graphing paper.

Step

Enter you data for the X-axis in column A and for the Y-axis in column B.

Step

Highlight both columns.

Step

Click "Chart" under the "Insert" tab.

Step

Select "XY (Scatter)" as the chart type and click "Next."

Step

Click "Next" if the data is correct, from what you originally highlighted.

Step

Choose any of the available chart options that you want to use and click "Next."

Step

Highlight where you want to put the chart and click "Finish."