The scatter chart is great for charting numeric values in pairs, for example, coordinates. It lets you compare multiple data series easily and you have more options when it comes to the axis settings than the line chart.
The scatter chart is an excellent choice if you want to graph data from engineering, science, and statistics. The image above shows data distributed unevenly across the x-axis, unlike the line chart.
How to build the chart
Select the data.
Go to tab "Insert" on the ribbon.
Click the "Insert (x,y) scatter or bubble chart" button.
Click the "Scatter" button.
The scatter chart lets you plot data with an x-axis set to logarithmic.