How to Make an X-Y Scatter Plot in Microsoft Excel. Two columns or rows of data in Microsoft Excel may contain useful information, but you'll just have a set of numbers.

In this example, you use the Fitness data set as the basis of your scatter plot. If you have not already done so, open the Fitness data set by following these steps ...

Scatter plots display data points with two- or three-dimensional markers. You can control the marker shape, size, and color with the markerShape, markerSize, and markerColor attributes. For example, ...