Excel Guides

Creating a Log Log Chart in Excel

A log-log chart is a graph that uses logarithmic scales for both the x-axis and the y-axis. Logarithmic scales are useful for data that spans several orders of magnitude, such as data on population growth or the spread of a disease.

To create a log-log chart in Excel:

  1. Select the data that you want to plot.
  2. Click the Insert tab, and then click Scatter.
  3. Click Scatter with only Markers.
  4. Click OK.
  5. Right-click the x-axis, and then click Format Axis.
  6. Under Axis Type, click Logarithmic scale.
  7. Click OK.
  8. Right-click the y-axis, and then click Format Axis.
  9. Under Axis Type, click Logarithmic scale.












Creating a

Log Log Chart in Excel