Hello,

I created a simple series consisting of two columns.

Column A contains the numbers 1, 2, 3, etc. through 50
Column B contains the formula =log(A2), etc where the cell references A2,
A3, A4,€¦ A51 correspond to the numbers in column A. The numbers and headings
are located in spreadsheet range A1:B51 I have pasted a comma delimited set
of the actual numbers below.

I then created two graphs. The first graph is a line graph of the series.
It shows the log curve. The second graph is an XY(scatter chart) of the
series. Both graphs show essentially, the same image: one is a line, the
second is a series of dots.

Using the €œadd trend line€� option with the scatter chart, I should be able
to add a trend line that traces the log curve. However, I see that adding a
€œlogarithmic€� trend line is not an option in Excel, or this logarithmic
series. I wonder why this is so, and if there is some way to add a
logarithmic trend line to a scatter chart. I have some data that is showing
a logarithmic pattern and would like to see the trend line included.

Following is a comma-delimited list of the numbers/formulas to be graphed.
Just past the headings and numbers into a range beginning with cell A1, make
sure the formulas are recognized as formulas, and you should be able to
recreate the graphs.

N,Log of N
1,=log(A2)
2,=log(A3)
3,=log(A4)
4,=log(A5)
5,=log(A6)
6,=log(A7)
7,=log(A8)
8,=log(A9)
9,=log(A10)
10,=log(A11)
11,=log(A12)
12,=log(A13)
13,=log(A14)
14,=log(A15)
15,=log(A16)
16,=log(A17)
17,=log(A18)
18,=log(A19)
19,=log(A20)
20,=log(A21)
21,=log(A22)
22,=log(A23)
23,=log(A24)
24,=log(A25)
25,=log(A26)
26,=log(A27)
27,=log(A28)
28,=log(A29)
29,=log(A30)
30,=log(A31)
31,=log(A32)
32,=log(A33)
33,=log(A34)
34,=log(A35)
35,=log(A36)
36,=log(A37)
37,=log(A38)
38,=log(A39)
39,=log(A40)
40,=log(A41)
41,=log(A42)
42,=log(A43)
43,=log(A44)
44,=log(A45)
45,=log(A46)
46,=log(A47)
47,=log(A48)
48,=log(A49)
49,=log(A50)
50,=log(A51)

Thanks very much,

Keith