Corbitt Associates logoCorbitt Associates logo hdr
Links to >>>>>>
:: Our Services
:: Good Reading
:: TechTIP Archive
 
Dear Executive,
 
Hints, tips, and how-to suggestions, delivered each week that you may find useful in your daily work. Please consider Corbitt Associates for help with your sales, marketing, or training needs.
 
*  Creating Logarithmic Graphs in Excel for Engineering, Medical and Financial Applications  *

Logarithms are useful to represent many occurrences found in nature; sound and light are two examples.  Logarithmic growth, or rate of change are also found in many engineering, medical and financial applications.  One difficulty in creating logarithmic graphs with Excel is that the one Logarithmic selection, which is found under Custom Types, does not provide more flexibility.  The default is a semi-log graph with the logarithmic axis being on the ordinate, and the linear axis being on the abscissa.

Our effort this week is to show you that semi-log, and log-log graphs can be created in Excel and that the logarithmic axis can be the ordinate, abscissa, or both (for log-log).  Because this need arises frequently in supporting our clients needs, we have created a stock library of logarithmic templates.  Explaining how we created all these templates is beyond the scope of this TechTIP, but making you aware that it can be done, and showing you these examples should help enable you to achieve similar results.  The other key point is that some of these charts were, and can only be created using the the XY (Scatter) graph, so if you have not investigated that chart type, now is a good time.

Graph 1: Semi-log, logarithm on ordinate

semi-log y axis

 

Graph 2: Semi-log, logarithm on abscissa.

semi-log x axis

 

Graph 3: Log-log

log-log

 

Graph 4: Two axis - semi-log on y1 and percent on y2

Two axis, semi-log y1 percent y2

 

 
Reader Feedback - Embedding Fonts
Another value-add tip I can use literally TODAY. I love it! Hope the % of readers of your TechTIPs benefit as frequently as I do from them. - Dave

Excellent tip on embedding the fonts.  I just got finished cleaning up a mess because I didn't have the same fonts on my computer as the guy who did the presentation for me. - Bob

Good tip!  I bet most people don't know about embedding......our marketing dept. has made this mistake in the past and sent us slides that open up completely differently and I've had to go back and remedy the problems. - Cathy 

Anyone who uses PowerPoint should subscribe to John Corbitt's free newsletter. This week's explains why you sometimes get wierd formatting when displaying a PPT presentation on a different PC and how to avoid that. Something I had trouble with. -JM

 

From the editor

Our last TechTIP for this year will be on 21 DEC 2005, and we will begin again on 11 JAN 2006.

 
ABOUT Corbitt Associates
Corbitt Associates provides sales, marketing and training capabilities, when you don't have resources available. Your resources may not have the required skill and experience, or they may be committed to another project. Don't let that program get behind, or go undone. Contact us, to be your extended team. When you can't Do It Yourself (DIY), we can Do It For You (DIFY).
 
If you wish to opt-out from this distribution list, click Unsubscribe and you will be automatically removed.

If you would like to contact us, please send email to: editor@corbittassociates.com

Corbitt Associates
3590 Lester CT SW
Lilburn, GA 30047-7504