Explanation:
1-Select all the cells that contain data
2-Click on the Insert tab
3-Look for Charts group
4-Under Chart group, you will find Scatter (X, Y) Chart
5-Click the arrow to see the different types of scattering and bubble charts
6-You can pause the pointer on the icons to see the preview in your document
7- Click on Scatter Chart
8-On Clicking, you will see the scatter chart.
9-You can quickly edit the chart by clicking the icons available on the right side of the chart