|
|
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): 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 |
|
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. |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |