Create Scatter Plot Graph Excel. There are spaces for series name and Y values. Showing the correlation of the variables.
In this example the data is arranged in rows. Aug 06 2013 If you are using Microsoft Excel youll need to select the data you want to turn into a scatter plot by clicking and dragging over it. We will go to the Charts group and select the X and Y Scatter chart.
Step 2 Now go to Insert menu and select the Scatter chart as shown below.
How to Create a Scatter Plot In this example we plot two series values in a scatter plot as a single group of XY coordinates. As before click Add and the Edit Series dialog pops up. In our case it is the range C1D13. In this example the data is arranged in rows.
