Google Answers Logo
View Question
Q: Creating a semi-logarithmic chart ( Answered,   1 Comment )
Subject: Creating a semi-logarithmic chart
Category: Business and Money > Finance
Asked by: kchua000-ga
List Price: $10.00
Posted: 25 Mar 2005 21:47 PST
Expires: 24 Apr 2005 22:47 PDT
Question ID: 500578
How do I create a semi-logarithmic chart in Microsoft Excel (Using the
chart to graph growth for sales, earnings, etc. for public companies. 
Need semi-logarithmic chart so I can fairly compare above mentioned
metrics across multiple companies with the same scale on charts.)?
Subject: Re: Creating a semi-logarithmic chart
Answered By: richard-ga on 26 Mar 2005 04:15 PST
Hello and thank you for your question.

Try these two methods for practice and let me know if they work for you.

Method 1:
Type a column of the following numbers, one below the other (say in
boxes A1, B1, C1 and D1):

Now select the column with the mouse and click on the chart 'wizard' button

You'll see a box with two tabs, 'standard types' and 'custom types'
Select 'custom types' and click on 'Logarithmic'

That should do it!

Method 2:
If you already have a non-logarithmic graph, click on its y-axis and
choose Selected Axis/Scale from the format menu.
Click on the 'logarithmic scale' button as shown and you should have
what you want.  See

Search terms used:
"chart wizard" excel semi-log

Thanks again for letting us help!

Google Answers Researcher
Subject: Re: Creating a semi-logarithmic chart
From: xarqi-ga on 26 Mar 2005 03:37 PST
Use an x-y scatter plot, and format the y axis to be logarithmic.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy