A scatter graph differs from the other kinds of graphs, because both axes measure values; there are no categories.You enter data for scatter graphs in the worksheet as follows:
Scatter graph data
Enter data-set labels in every other cell along the top row of the worksheet, starting with the first cell. These labels will appear in the legend.
Enter y-axis data in the first column and x-axis data in the second column.