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.
2. Insert a Scatter graph.
3. Right click both axes and click Format Axis.
4. In the Format Axis box, within the Axis Options tab, check the Logarithmic scale checkbox.
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.
8105
11/19/2012 9:58:06 AM
We love feedback! Please help us improve this article.
Article Rating:
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!