Infinite opportunities?  Endless problems?  Limited resources?  Talk to us!
Operations and
Technology Consulting		 Publishing and
Training 		Excel add-ins
and tutorials, charts, tips		 VBA
tutorials		  PowerPoint
Add-Ins and tutorials		 Miscellanea
You are on the Home/Excel/Tutorials/Flexible Log Scale page
About this site
Google
Web
This Site  

Excel 2007 includes this capability.  Create the chart, then right-click the axis and select Format Axis... | Axis Options tab.  Check on the 'Logarithmic scale' checkbox and set the minimum, maximum, and major unit values as desired.

For earlier versions of Excel, follow the steps in the tutorial below.

Tutorial

Downloadable PDF file (flexible-log-scale.pdf) (requires Adobe Acrobat)

Downloadable help file (flexible-log-scale.chm)

Keywords: log scale, any values on axis, axes, non default gridline

 

For custom technology solutions, operations consulting, or training contact web-underscore-contact@tushar-hyphen-mehta-dot-cee-oh-em.
By accessing any page or link on this web site other than this page, you agree to the terms and conditions.

Ads from amazon.com
[Optional] Survey (current rating of site: 3.7 out of 4)  If you will take a moment to provide your comments, it will help improve the site both for you, and for other visitors.

On a scale of 4 (just what I need)
to zero (totally useless)

 How do you rate the information

on this page?

   on this site?

[Optional]

Your name
Your email address
Other comments
 
Monitor page
for changes

it's private
by ChangeDetection
A comment selected at random:
Copyright © 2000-2008 Tushar Mehta.
Send comments and suggestions about the web site to webmaster@tushar-hyphen-mehta-dot-cee-oh-em
Last edited February 28, 2009