My request was:
> Anybody know an Excel Addon that will give tick marks and tick mark labels
> using logarithmic scales *between* 1 and 10, 10 and 100, 100 and 1000,
etc?
>
> Or another program that has this facility?
There were three recommendations for Sigmaplot, two for Stata (one with
detailed guidance), and a variety of other solutions.
Thanks to Dennis Chanter, Sally Hollis, Susan Charman, Brian G Miller, Haas
Joseph, Iain Buchan, and Victor Kiri, Jay Warner, Bob Peacock, and Allan
Reese.
*************************************
You could try Sigmaplot
*************************************
For publication-quality graphics, we use Sigmaplot, from Jandel Scientific.
This is very flexible and handles log axes.
**************************************
SigmaPlot (SPSS Inc.former Jandel Scientific Software) can do the job.
***************************************
STATA will do this.
**************************************
Stata is a package that I have recommended for over ten years because of its
excellent and versatile graphics. Unfortunately, so many people tell me
that it is too difficult because it is "command based" and not GUI.
Two advantages of being command-based are that you can obtain a log of
each session so that you can review (and repeat) how the results were
obtained, and that I can provide solutions or templates rather than stand
by the user saying, "Click there. No not there! One millimetre higher".
A basic scatterplot is obtained by the command
graph yvar xvar
Either or both scales can be plotted logarithmically, with ticks labelled
in the untransformed values [comma separates varnames from options]
graph yvar xvar, xlog
graph yvar xvar, ylog xlog
graph yvar xvar, xlog xlabel(1,2,3,4,5,6,7,8,9,10)
graph yvar xvar, xlog xlabel(1,10,100,1000) [A]
If you wanted a logarithmic scale but labelled with the transformed values,
you would transform the variable first
generate xlog=log10(xvar)
graph yvar xvar, xlabel(0,1,2,3) [B]
[A] and [B] would show similar data patterns, differing only in the labels.
*********************************
DeltaGraph, from DeltaPoint, Inc. Now, I believe, a part of Adobe.
Works. More & more flexible graphs than Excel, by far. Less computational
ease than Excel. Understandable.
****************************************
I used 2 new data series with the tick marks as points. I then made
the points look as much like tick marks as i could by:
x axis: told it to use no symbol, but to put on zero width error bars (what
you see is the tick at the ends of the error-bars). y axis used a symbol
that looked like a tick mark (-) in a small point size.
This method is clearly not automatable, but may work quite well for one-off
graphs.
*********************************
I believe the old symphony software (replaced by Lotus 123 in the early
1990s) has that facility.
"AXIUM", a more recent software (graphics companion to the
mathematics/engineering software, MATHLIB,
but sold separately) may also have the facility.
***********************************
I have recently completed some graphs with log scales using SPLUS. There is
a function to draw the scales but I used SPLUS programming commands to do my
own. I did not need to have intermediate "ticks" but I'm pretty sure it
would be straightforward. I still have the commands if you need them.
**************************************
The chart maker facility in StatsDirect does log scales - see
http://www.statsdirect.com for a free 10 day trial to download.
*************************************
GNUplot is an excellent graphical freeware and should do the job also.
****************************************************
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
|