Author: Oscar Cronquist Article last updated on August 30, 2018

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

  1. Select the data.
  2. Go to tab "Insert" on the ribbon.
  3. Click the "Insert (x,y) scatter or bubble chart" button.
  4. Click the "Scatter" button.

X-axis logarithmic

The scatter chart lets you plot data with an x-axis set to logarithmic.

  1. Double click with left mouse button on x-axis.
  2. Go to the "Axis Options" on the settings pane.
  3. Click on check box "Logarithmic scale".
  4. Change the base to 10.