Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Filtering Columns for Unique Values
Printing Multiple Worksheets on a Single Page
Excel is great at automatically creating a wide variety of charts, lickety split. For some types of data, you may want to create a chart that is not readily apparently. Such is the case with a log/log chart.
The answer to this conundrum is to change which type of chart you use for your data. It seems that Excel will not allow the X axis to use a logarithmic scale for many types of charts. To specify a chart where you can use logarithmic scales on both axes, follow these steps if you are using a version of Excel prior to Excel 2007:
If you are using Excel 2007, follow these steps:
If, for some strange reason, values along the X axis are still not represented in logarithmic scale, you can click on the X axis, choose to format it, and then specify a logarithmic scale.
You should note that this solution will work for many types of charts, but won't work for charts where you need to plot zero or negative values. (Those values don't have a LOG value.)
So why do you need to use a scatter chart for log/log data? Because it is the only type of chart that allows numeric values along the X axis. Other chart types use the X axis for categories of information, not numeric values.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3025) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Save Time and Money! Many people need to keep track of employee time, but don't know where to start when it comes to creating a spreadsheet. Here's a way to save time, effort, and money with ready-to-use timesheet templates.