graph won't let me have less than 1 for logarithmic scale

[leecavturbo]

i need logarithmic scale but with the bottom axis starting a -10
.

 

[leecavturbo]

no one!

 

[Legacy 14611]

I can't really see your data or just what you are trying to do.

However, standard Excel procedures can only interpret/use logarithms of positive numbers.

The logarithm of 0 is unbounded negative and can't be show on an Excel graph. Logarithm of negative number is a complex number (with "real" and "imaginary" parts) and even harder to show using standard inbuilt Excel procedures.

Even the great (blind) Swiss mathematician Leonhard Euler called complex numbers "impossible numbers", for probably similar reasons to Luca Pacioli's invention of double entry bookkeeping about 1491 because he considered the bookkeepers of his time couldn't understand negative numbers. Did his wonderful invention add to or did it obstruct human intellectual progress? Now that's an interesting question.

Anyway, maybe this is your problem, i.e. trying to make graph of complex numbers, or maybe it lies elsewhere. Without more specific info I can't tell.

 

[leecavturbo]

i just have some data that plots along the 0 and 1 values that i would like to see.
so an x axis scale from -10 to 10,000 would have been ideal

 

[Legacy 14611]

That's still not enough information to base a useful response on.

You may like to provide a few specific numbers and say just what you want done with them.

e.g. which ones do you mean to take the logs of? what do you want to appear on your horizontal axis? the values themselves or the logs of the values? Why don't you just take the logs of the numbers, put them in a table, and chart them, just like any other excel chart?

I presume you're trying to add a logarithmic trendline to a chart.

If Excel obdurately refuses to do this, and you're sure that all relevant values are non-complex/non-imaginary then it's not that much harder to do it more manually, or automate the process with a macro or whatever.

Without seeing even some illustrative data that you consider Excel won't chart, when it should be charting it, then I can't say much more.

 

[wsjackman]

what is the minimum positive value you want to plot"

do you really mean 10^-10 as the min

then put minimum 0.0000000001