Har har

---

Very interesting. I never thought logarithmic scales would lighten up my life ;)...

Posted by SunBeam on March 20, 2006 at 05:19 PM.

Tip

---

Just remember to use the normal values when you select source for the graphic, Excel does the log operation for you.

Posted by Mika on March 21, 2006 at 01:18 AM.

Hello, sort anoob here

---

hello ladies and gents!
I've been kind of lurking around.
I love this site! thanks for having me :)






Posted by Nanbe1st on October 16, 2006 at 06:49 AM.

thanks

---

you just made my day
thanks so much for your help
i was able to find this site on the 1st page of google

assignment done!
:D

Posted by mr.mackey on January 24, 2007 at 02:17 AM.

Y crossing point

---

How can I have the Y axis cross the X axis at its MINIMAL value (X axis being logarithmic)?

Thanks in advance

Posted by anne on March 5, 2007 at 11:06 AM.

Limitations of logarithmic graphs in Excel

---

Unfortunately Excel is only able to use powers of ten as minimum and maximum values of the logarithmic axes.

But logarithmic scaling is not only useful for a wide data range. It is very convenient if data graphs become descriptive, i.e. if exponential data becomes a straight line. If this data is spread over less than one, or two decades, the limitation to powers of ten reduces the perceptibility of the graph.

Erich



Posted by Erich on March 21, 2007 at 05:21 AM.

Double logarithmic scales

---

I've wondered how to make double logarithmic scales?!

Posted by Jeppe on March 23, 2007 at 11:12 AM.

Graphing Dilemna

---

I'm trying to graph values in log scale, and when I check the box to do so, the dates on the x-axis move up to the top of the chart, and I can't find the option to have them appear on the bottom. Any help?


Posted by Derek on July 13, 2007 at 10:26 AM.

Hello There

---

2002-03 2003-04 2004-05 2005-06 2006-07
MOT 371,71 408,59 514,97 582,54 700,97
DBT 38,40 45,79 57,99 70,02 92,97
HSS 10,35 10,92 10,37 10,38 11,29
ICPR 0,75 0,83 0,72 0,75 0,78
DIF 88,30 93,61 120,65 160,98 197,72

Whenever I make graph from above mentioned data and adjust log scaling as 0, 1000, 10, 10, 0 and check logarithmic scale, it automatically changes into 0.1, 1000, 10, 10, 1 and check logarithmic scale. Could you please help me. Thanks & regards, LA


Posted by LUX on November 1, 2007 at 06:28 AM.

Possible solution

---

You can try to use point (.) instead of (,) when you write numbers, it might consider those are different numbers.

Posted by Indy on November 3, 2007 at 10:48 AM.

ECE

---

LIFE sucks!!!

Posted by Enkei Tancado on November 12, 2007 at 10:58 PM.

values on x-axis

---

hallo all,

How can i show values on the x-axis which has a logarithmic scale? values such as...0.001,0.1,1,10,100,... are shown by the program. What can i do to show x-Values such as 34, 63 or 0.0063.

Thank you in advance.



Posted by simeneh on November 14, 2007 at 08:11 AM.

TY for the post

---

Great post. this has stumped me for some time. I used to do the log values myself and then graph those.

Once again, thank you. Your insight was much appreciated as it was clear and concise.

Posted by ER sdfghjk on November 27, 2007 at 11:00 PM.

Another Comment

---

Another thing I noticed is that it helps if you choose to graph it in a scatter graph, it allows for double logarithmic scales (if you need it).

Posted by Betty on December 3, 2007 at 01:40 PM.

scaling

---

How did you do this? When I try to do it like yours, Excel 2003 complains logarithmic scale must be greater than 10. It won't let me do 0.1 like yours.

Posted by logarithmic on March 16, 2008 at 07:13 AM.

Negative values

---

Anyone have a trick in order to insert negative values in a log10 scale? I have a bunch of sin funtions (ranging from .05 to 6e18 in amplitude).

Thanks,

Posted by Alex on March 16, 2008 at 01:54 PM.

interesting

---

Thank u very much
that is what i'm looking for

Posted by mohammed saad on March 30, 2008 at 08:15 AM.

THANK YOU!!! LIFE SAVER

---

i was stuck on my lab. You r such an life saver!!!
THANK YOU!!!!!

Posted by stuckonlab on March 31, 2008 at 12:18 PM.

semilog graph

---

hi. how to plot a semilog graph? i meant a lin-log graph with only x-axis in log scale? pls help. urgent. thanks.

Posted by carmen on April 11, 2008 at 11:55 PM.

semilog scale

---

For semilog scale, change only x scaling to logarithmic.

Would give a straight line with bubble's data - try it!

Posted by john on April 30, 2008 at 05:38 AM.

graphs and scales

---

how can i know about scales and the importance of graphs or where cn i find it plus it has to be more than 300 words and also has to be submitted on monday

Posted by oyinlola on May 24, 2008 at 05:34 AM.

log and exp

---

I logged all of my data and plotted it but now want my legend to show the orignal non-logged data. AKA exponetiate the values currently in the legend. Is this possible?

Thanks!!

Posted by exponentiate me on June 18, 2008 at 04:13 PM.

add standard deviation

---

Hi All,

Anyone has an idea on how to add error bar on each of the data. how do i arrange the data set before i begin?
Thanks

Posted by sukor on July 4, 2008 at 12:38 AM.

Operations Research Analyst

---

Hello:

I have no idea how to convert data such as 100,96,84 into log using excel. Can anyone help me? I am using the learning curve to predict cost and I am unsure of how to change my values to logarithm to get make my model linear.

Posted by monica on August 7, 2008 at 01:33 PM.

Help urgent

---

i am working in vista and am totally at a loss on how to display the values of minor grid lines when using semi log scale on x axis, plz help.....

Posted by kashif hasnat on August 9, 2008 at 01:03 AM.

Excel y axis log plots before the current release: Bad for stock plotting

---

The log plotting limitation of the minimum and maximum to powers of 10 really limits the candlestick plot's utility. Other than upgrading to 2007 version, anyone have any thoughts on how to fudge this/ For example, if I spreadsheeted the logs of the open-high-low-clase and used linear scale, that would get the plot correct, but how do I fudge the values displayed on the Y axis to the original values?

To the question regarding negative values on a log plot: There aren't any such.

Posted by NeverLift on September 24, 2008 at 01:53 AM.

Mr.

---

I can not find the option for Logarithmic scale in the category axis options

Posted by Gnanchandra.s on March 31, 2009 at 02:26 PM.

booyah

---

nice one
totally forgot how to do this
one search and right on the money

BIZNASS!!!!!

Posted by popeye on May 1, 2009 at 05:51 AM.

SuzukiPilot

---

Hi i am trying to get a Log scale of 10 - 2000 on the x axis. I am only able to get either 1000 or 10,000. Does anybody have a suggestion how i can get the scale down to 2000 please?

Posted by Steve on June 10, 2009 at 07:54 AM.

Adding a trendline to log scale

---

I've managed to graph my data using a double log scale (that is both the x and y axis are in log scale) but I'm not able to add a linear trendline. Well, technically, I'm able to add the trendline, its just not linear. It's quite curved... but when I go to options to format the trendline, its definitely the linear option. Any ideas?

Posted by Kara on July 2, 2009 at 06:20 PM.

Adding a trendline to log / log plot

---

Remember that a straight line on a log/log plot is actually a power law. Something like y = x^z.

You can add a straight line to log/log plot by fitting a "power" trendline.

Posted by gerry on August 6, 2009 at 11:18 AM.

GOOD JOB BRO

---

thank yau bro...vary good info...you safe me bro...

Posted by RIZAL on September 10, 2009 at 04:10 AM.

minor gridlines

---

I've been using log plots a long time, but somehow never clicked "show minor gridlines." Now I feel like an idiot, but at least I can show resolution tighter than a decade!

thanks

Posted by Brent on November 25, 2009 at 10:50 AM.

Tush

---

Excelent article, you are a lifesaver, thank you

Posted by Tush on December 8, 2009 at 02:03 AM.

Negative values

---

Yes, there are such a thing as negative values.

For example, if you want to display a set of power levels recorded in dBm (decibels relative to milliwatt). Any values below 1 mW will be negative, but they will be log scale. How do you get Excel to display these negative values in log scale?

Posted by Matt on December 8, 2009 at 10:55 AM.

Finding points

---

After I have my points setup and I have my graph... how can I find specific points on the line?? Like how do I find the x-value when I know the y-value??

Posted by Rocky on January 21, 2010 at 11:19 AM.

how to draw linear trend line for log vs log plot

---

dear friends
i am drawing a plot log vs log and want to draw linear trend line but it is coming in parabolic, so help how to draw
thx in advance

Posted by anything on January 23, 2010 at 04:37 AM.

RE: linear trend line

---

Do a log transformation of the data and then you can plot a straight trend line to it easily

Posted by Brian P on February 3, 2010 at 07:07 AM.