Logarithmic Scale Moves X-axis to Top of Graph

[BSCND99]

I am creating a scatter graph using a logarithmic scale. When I change the scale to logarithmic, the values on the x-axis move from the bottom of the graph to the top. How can I correct for this to keep the x-axis values at the bottom? Thanks.

 

[ragav_in]

I tried a sample chart and when I changed the X-Axis to logarithmic scale, it did not move to the top as you said. If you could give some sample data you use it would be able to sort the problem

regards
ragav

 

[BSCND99]

Age Range L(x)
0 - 4 1
5 - 9 0.972972973
10 - 14 0.963963964
15 - 19 0.963963964
20 - 24 0.963963964
25 - 29 0.954954955
30 - 34 0.936936937
35 - 39 0.90990991
40 - 44 0.891891892
45 - 49 0.855855856
50 - 54 0.801801802
55 - 59 0.792792793
60 - 64 0.720720721
65 - 69 0.612612613
70 - 74 0.540540541
75 - 79 0.414414414
80 - 84 0.27027027
85 - 89 0.117117117
90 - 94 0.036036036
95 - 99 0.009009009

That's the data I'm working with - can't figure out why the x-axis moves to the top. Have tried to change the formatting to move the x-axis down without any success. Any potential ideas are appreciated!

 

[tusharm]

First, you cannot be using a Scatter chart since your x-values are not numeric but text ranges (95-99 for example). Not that that matters...

I suspect the x-axis moves to the top because all your y-values have negative log values (except 1 which becomes zero). By default, the x-axis intercepts the y-axis at y=0, which for a log scale translates to an original y-value of 1.

You can solve this problem by double-clicking the y-axis. From the 'Scale' tab in the 'Category (X) axis crosses at' field enter a very small number such as 0.00000001. Don't enter zero. For obvious reasons it won't work. Make sure the corresponding 'Auto' checkbox is *unchecked.*