Indiana University
University Information Technology Services
  
What are archived documents?
Login>>
Login

Login is for authorized groups (e.g., UITS, OVPIT, and TCC) that need access to specialized Knowledge Base documents. Otherwise, simply use the Knowledge Base without logging in.

Close

In Microsoft Excel, how can I make a log-log graph?

To create a log-log graph in Microsoft Excel, you must first create an XY (scatter) graph. This is the only graph type that will work; other graph types permit logarithmic scales only on the Y axis. For information about how to create an XY (scatter) graph, see Using Microsoft Excel, how do I make a chart using one set of data as the X-axis? To create a log-log graph, follow the steps below for your version of Excel.

Excel 2007

  1. In your XY (scatter) graph, right-click the scale of each axis and select Format axis... .

  2. In the Format Axis box, select the Axis Options tab, and then check Logarithmic scale.

Other versions of Excel

  1. In your XY (scatter) graph, double-click the scale of each axis.

  2. In the Format Axis box, select the Scale tab, and then check Logarithmic scale.
This is document abrv in domain all.
Last modified on May 13, 2009.

Comments/Questions/Corrections

Use this form to offer suggestions, corrections, and additions to the Knowledge Base. We welcome your input!

If you are affiliated with Indiana University and would like assistance with a specific computing problem, please use the Ask a Consultant form, or contact your campus Support Center.

Contact Information

Note: We will reply to your comment at this address. If your message concerns a problem receiving email, please enter an alternate email address.