A Scatter Chart has two value axes to show one set along a horizontal axis and another set along a vertical axis, then the points are presented in the intersections of horizontal axis (X) and vertical axis (Y).
The difference between a scatter chart and a line chart is that a line chart displays data over time by categories, while a scatter chart displays the relationship between X axis and Y axis. Please follow the steps below to make a Scatter chart:
Step 1: Select the data with X axis and Y axis (e.g., height and weight);
Step 2: Click the "Insert" Tab from the ribbon;
Step 3: Click the "Insert Scatter or Bubble Chart", and select the Scatter chart;
Step 4: A Scatter Chart will be created.
Step 5: Change Chart Title: Click on the title then select the words inside the box to replace with the proper ones;
Step 6: Add Data Labels: Right click on the scatter chart, in the dialog box, select "Add Data Labels", this by default will add Y axis value.
To add both x axis and y axis values, right click the Y axis value added above, then select "Format Data Labels", in the "Format Data Labels" window, select X value and Y value.
Step 7: Format Axis: Right click on X (or Y) axis, in the dialog, select "Format Axis", change the value of "Axis Options" to adjust the chart.
You can also double click on X axis or Y axis to bring up the Axis Options window.
