Scatter plots display data as discrete points and with or without lines between them.
To create a scatter plot, select your data in the worksheet and click the Chart button. Choose X-Y from the Chart menu and a dialogue box will appear.
Click on the button for the type of scatter plot you want.
Specify whether the data series are in columns or rows.
Specify how the data series are arranged. X, Y, Y means that you want to plot more than one y-series against a single x-series. X, Y, X, Y means that for each y-series you are supplying an x-series.
Specify whether the first series is data or labels.