Return to Charts Home

Log-Log Plot in Excel & Google Sheets

Written by

Reviewed by

Steve Rynearson

Last updated on October 30, 2023

Log-Log Plot in Excel

We’ll start with data that shows values for the X and Y Axis.

Starting Graph for Log Log Graph in Excel

Creating a Scatterplot

Highlight the data
Select Insert
Click Scatter
Select the first Scatterplot

Create Scatterplot for Log Log Graph in Excel

Change X Axis to Logarithmic

Right click on the X Axis
Select Format Axis

Format X Axis for Log Log Plot in Excel

3. Check the Logarithmic Scale

Switch X Axis to Logarithmic Scale in Excel

Change Y Axis to Logarithmic

Right click Y Axis
Select Format Axis

Format Y Axis to Logarithmic Scale in Excel

3. Click on Logarithmic Scale

Change Y Axis to Logarithmic Scale in Excel

Log-Log Plot in Google Sheets

Select Data
Click on Chart

Create Graph for Log Log Graph in Google Sheets

3. Change the Chart Type to Scatter Chart

Change Chart Type to Logarithmic Scale in Google Sheets

Change X Axis to Logarithmic

Select Customize
Click Horizontal Axis
Check Log Scale

Change X Horizontal Axis to Logarithmic Scale in Google Sheets

Change X Axis to Logarithmic

Select Customize
Click Vertical Axis
Check Log Scale

Keep in mind you can adjust the Scale Factor for the X and Y Axis

Change Vertical Y Axis to Logarithmic Scale in Google Sheets

Final Log-Log Plot in Google Sheets

Final Log Log Plot in Google Sheets