How to display exponents on excel chart??

[Tim]

Hello,

Is there any way to display exponents on the y axis of
an excel chart?? I want a log graph that has 10^1,
10^2, 10^3,10^4 etc. . . All I can seem to find is how to
display either the whole numbers or scientific notation
(1.00 E + 02) none of which is acceptable to publish in
the Scientific Journals we use.

So far I can only do this in Cricket Graph and it is a
pain to have to export my data to Cricket everytime I
want to make a graph. Any help would be greatly
appreciated by me and my boss who always gets on
my case about my graphs. ha ha :)

Thanks,
Tim

[S...@internet.org]

1. Plot some points (with x-value = 0) where you would
like the labels, say (0,10), (0, 100) etc.

2. Create a column of labels using the Journals' desired
display format, then use Rob Bovey's
Chart Labeler add-in (http://www.appspro.com/) to
attach data labels to the points in Step 1.

3. Remember to turn of Excel's y-axis labeling from the
Format Axis dialog.

- Sam

"Tim" <tbmat...@ucdavis.edu> wrote in message news:19c7401c1316a$90a0db80$b1e62ecf@tkmsftngxa04...

[Tim]

Thanks Sam. . . .

I guess I wasn't expecting that kind of a response. I
am stuck working on a mac at work. Your idea will
definately help me on my home computer, but are
there any alternative to getting this done on a mac.

Thanks,
Tim

>.
>

[Jon Peltier]

Hi Tim -

You can use a dummy series to create a dummy axis with the
formats you want. I made a dummy chart with a logarithmic
X axis ranging from 0.01 to 1000. I formatted this axis
so that it had no labels. My dummy series was X = {0.01,
0.1, 1, 10, 100, 1000} and Y = {0, 0, 0, 0, 0, 0} so it
fell along the X axis with points at the axis tick
locations. My labels were generated in a parallel range
to the X data, using the formula ="10"&log(cell containing
X value), which produced {10-2, 10-1, 100, 101, 102,
103}. I used Rob Bovey's XY Chart Labeler to apply these
labels to the dummy series, placing the labels below the
series (i.e., below the axis where axis labels would go).
Finally, I ran the following stupid little macro to apply
superscript formatting to the appropriate characters of
each label.

Sub ExponetiateTheLabels()
' put nice superscripts for 10^-1, 10^1, etc.
' Use Rob Bovey's XY Labeler to put data labels on dummy
series
' that replaces standard axis tick labels
Dim labl As DataLabel
For Each labl In ActiveChart.SeriesCollection(2).DataLabels
With labl
' convert data label's cell reference to text
' but make sure it won't be considered a date
' 10-1 means October 1st
.Characters.Text = "'" & labl.Characters.Text
' superscript characters of label
.Characters(Start:=4, Length:=2).Font.Superscript
= True
' remove leading single quote
.Characters(1, 1).Delete
End With
Next
End Sub

You can fiddle with this for whatever kind of axis you
have.

- Jon

>.
>

[Tushar Mehta]

Four options. Don't know which one will work for you.

(1) Install Rob Bovey's add-in at home. Copy the .xla file over to the
work computer.

(2) Install Chartlabeler on your home computer, get into VBE, and copy
the code to your own XL file. Transfer the file to the Mac and create
the add-in there.

(3) Do (2) but use the code without creating the add-in. Just leave it
in a xls (equivalent) file on the Mac.

(4) Ask Rob if he'll put a version of the xla file on his website w/o
wrapping it in a .exe installer program.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
--

In <19b4601c13183$5dd17750$9be62ecf@tkmsftngxa03>, Tim
<tbmat...@ucdavis.edu> wrote