How To Do Log Scale In Excel

Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not piece of work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Creating a Log/Log Nautical chart.

Creating a Log/Log Chart

Excel is groovy at automatically creating a wide variety of charts, lickety separate. For some types of data, you may want to create a chart that is not readily apparent. Such is the example with a log/log chart.

The reply to this conundrum is to change which blazon of chart you use for your data. It seems that Excel will not allow the Ten axis to use a logarithmic calibration for many types of charts. To specify a chart where y'all tin can apply logarithmic scales on both axes, follow these steps:

1. Select the chart area.
2. Make sure the Chart Design (Design in earlier versions of Excel) tab of the ribbon is visible. (This tab is only bachelor if you lot select the nautical chart area, as instructed in stride 1.)
3. Click the Change Chart Type tool in the Type grouping. Excel displays a palette of bachelor nautical chart types.
4. Select the XY (scatter) type of chart.
5. Select the sub-chart blazon you want to use.
6. Click on the OK button.

If, for some foreign reason, values forth the X axis are still non represented in logarithmic scale, you can click on the Ten centrality, choose to format information technology, and then specify a logarithmic scale.

You should note that this solution will piece of work for many types of charts, but won't work for charts where you lot need to plot zero or negative values. (Those values don't have a LOG value.)

And so why do you need to use a scatter nautical chart for log/log data? Considering it is the merely type of chart that allows numeric values along the X axis. Other chart types utilize the X centrality for categories of information, not numeric values.

ExcelTips is your source for toll-effective Microsoft Excel training. This tip (10316) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You lot can observe a version of this tip for the older carte interface of Excel hither: Creating a Log/Log Nautical chart.

Author Bio

With more than fifty non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. Learn more well-nigh Allen...

More than FROM ALLEN

A Shortcut for Switching Focus

Word provides keyboard shortcuts for lots of things, but it doesn't provide 1 for switching to the desktop and back to ...

Discover More

Determining an ANSI Value in a Macro

Need to know the character code used for a particular grapheme? In a macro you can employ the Asc function to make up one's mind the ...

Discover More

Stopping Screen Shifting

When your screen doesn't bear as you expect, it could be because of the Scroll Lock on your system. Here's what to check.

Find More

More than ExcelTips (ribbon)

Making Sure that Data Accompanies a Chart

When sending a chart to someone else, it tin can be frustrating for the other person to open the workbook and see errors ...

Discover More

Controlling Chart Gridlines

Gridlines are often added to charts to help improve the readability of the chart itself. Here's how y'all tin can control ...

Discover More

Exploded Pie Chart Sections

Want to modify the groupings used by Excel when it creates pie charts? Your options are express, as y'all acquire in this tip.

Notice More

Source: https://excelribbon.tips.net/T010316_Creating_a_Log_Log_Chart.html

Posted by: presleyhimese54.blogspot.com

Share this post