How to Make Logarithmic Graphs on Excel

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Email

Microsoft Excel contains a powerful graph utility that can make professional-looking charts in seconds. A logarithmic scale is a scale that represents the logarithm of a quantity instead of the quantity itself. Logarithms can come in handy when referencing a large range of values on a graph. Although you can create a variety of graphs in Excel, the only chart type that supports log-log graphs, where logarithmic scales are on both the y- and x-axis, is the scatter graph.

Skill level:
Moderate

Other People Are Reading

Things you need

  • Existing Excel datasheet with X and Y values

Show MoreHide

Instructions

  1. 1

    Highlight the data on the datasheet by clicking at the top left and then dragging the cursor to the bottom right.

  2. 2

    Click "Insert" and then click "Scatter." Click the first scatter icon and Excel inserts a scatter chart into your spreadsheet.

  3. 3

    Right-click the scale of the x-axis and then click "Format Axis." Click the "Axis Options" tab and then click the "Logarithmic Scale" check box.

  4. 4

    Right-click the scale of the y-axis and then click "Format Axis." Click the "Axis Options" tab and then click the "Logarithmic Scale" check box.

Tips and warnings

  • In previous versions of Excel, the "Logarithmic Scale" check box is located in the "Format Axis" box on the "Scale" tab.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.