How to create scatter chart in MS Excel

Select the data
go to insert
scatter,here are more options
 1-lines with marker,
 2-only line, select required,
 3-only markers
right click on the chart,
move the chart to new sheet, if required.
right click on RD, below chart
Format axis