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

This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.

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. To create a log-log graph, follow the steps below for your version of Excel.

Excel 2010 or 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 the Knowledge Base.
Last modified on 2018-01-18 08:48:38.

Contact us

For help or to comment, email the UITS Support Center.