Google Answers Logo
View Question
 
Q: Creating a semi-logarithmic chart ( Answered,   1 Comment )
Question  
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.)?
Answer  
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):
10
100
1000
10000

Now select the column with the mouse and click on the chart 'wizard' button
http://www.fairfax.bham.sch.uk/geograph/ks3frame/Image85.gif

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.
http://wwwfp.vuse.vanderbilt.edu:8888/es130/lectures/lecture6/plot_t7.gif
Click on the 'logarithmic scale' button as shown and you should have
what you want.  See
http://wwwfp.vuse.vanderbilt.edu:8888/es130/lectures/lecture6/plot_types.html

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

Thanks again for letting us help!

Sincerely,
Google Answers Researcher
Richard-ga
Comments  
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 answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


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