Microsoft Excel 2007: Making a Log-Log Graph

Archived Historical Data: Not Actively Maintained.

This article will explain how to create a log-log graph in Excel 2007. To create a log-log graph in Microsoft Excel, you must first create an XY (scatter) graph. You must use an XY (scatter) graph because it is the only type of graph in Excel 2007 that will allow you to make both the graph's x and y axes logarithmic scale.

To make an XY (scatter) graph and format it as a log-log graph, follow these steps:

1. Select the data that you want to put into a log-log graph.

Screen shot of step one

2. Insert a Scatter graph.

Screen shot of step two

3. Right click both axes and click Format Axis.

Screen shot of step three

4. In the Format Axis box, within the Axis Options tab, check the Logarithmic scale checkbox.

Screen shot of step four

After doing that for both axes, you will have set up a log-log graph. Any functions of the form y = ax^b should appear as a straight line on the log-log graph.

Functions of the form y=ax^b should be straight lines.


11/19/2012 9:58:06 AM  

We love feedback! Please help us improve this article.

Article Rating:
Email Address:
(Optional, unless you would like to hear back from us)
GROK is a resource of Louisiana State University developed and maintained with support of the LSU Student Technology Fee.  We love getting feedback from the general public, but our one on one support efforts are generally dedicated to the LSU community.  Thanks for your understanding!
"" ""

Information Technology Services
200 Frey Computing Center · Baton Rouge, LA 70803
Telephone: 225-578-3700 · Fax: 225-578-6400 · E-mail:

Copyright © 2006. All Rights Reserved. Official Webpage of Louisiana State University.