How to plot semi log graph in Excel? - Excel Help Forum
Apr 10, 2006 · > I want to plot a semi log plot in excel along with grid lines. Can anyone > tell how to do? Thanks for your help. But the how to plot Log-Log graph? There is no 'logaritjhmic scale' option on x axis. Sorry for bothering again.
semi log and log log plot in excel - Excel Help Forum
Apr 8, 2014 · Follow instructions here for formatting the value (Y) axis to enter the appropriate dialog. Check the "logarithmic axis" option (with desired logarithm base). this will create a semi-log plot. Since the X axis is also a value axis, repeat the same procedure for the x axis when creating a log-log plot.
Calculating a slope by the function and graph on a semi-log graph
Feb 22, 2014 · I note that, if I plot and regress based on common log (log 10), then I get m=-14364. If I regress on natural log (ln() or log e), then I get m=-33075. I am guessing that in one case Excel is using common log and the other is using natural log. Whichever one you decide is "the correct" way to express it, make sure you are clear which base you ...
how do I set a semi-log plot on Excel - Excel Help Forum
Apr 30, 2005 · Create your chart. Double click on the vertical axis, and on the scale tab, check the Logarithmic Scale box. If you decide you want a log-log chart, you need to start with a scatter chart, In a
Semi-log plot with one y variable and two x variables? - Excel Help …
Feb 16, 2013 · Re: Semi-log plot with one y variable and two x variables? Well, I've tried just selecting the optical density, predicted cell number, and actual cell number columns (with titles, columns listed in that order) and clicking the "Smooth Marked Scatter" chart option, which, as you predicted, automatically makes OD my x-axis.
Create semi-log plot for percentage - Excel Help Forum
Dec 21, 2005 · I am trying to make a (reverse??) semi-log plot with the y-axis to display 0.9, 9, 99, 99.9, 99.99%. On the x-axis I want concentrations of 0.0, 0.01, 0.05, 0.10, 0.25. I have used the scatter plot with the logarithmic funchtion selected...but that gives me 10,100,1000....I can seem to figure out how to get it to do what I need.
How to find the gradient and intersection in a log-log plot?
Apr 13, 2016 · I then plotted a vs. b in a log-log plot. I want to find the gradient in the log-log plot and the intersection point where x=0. I can do this without using the graph itself by using the following excel-formula: SLOPE(LOG(F15:F18);LOG(E15:E18)). Then I got -0.28 as the gradient. The expression for the trendline: y=-0.2.896*ln(x)+23.397.
Trend Line Semilog Plot - Excel Help Forum
Feb 17, 2014 · I needed to graph a semilog plot that went on the y axis from 1-100 and on the x axis from 0-51, then graph a few points and find a line of best fit. I did this on excel without any problem, using trendline for the line of best fit. I got a really nice graph that was exactly what I …
Problem with Custom Error Bar in Semi-Logarithmic Plot - Excel …
Jun 6, 2014 · Join Date 07-08-2012 Location Digital Nomad... occasionally based in Ireland. MS-Off Ver O365 (PC) V 2406 Posts ...
Plotting Zero Values (Logarithmic Scatter Plot) - Excel Help Forum
Oct 30, 2013 · When I Google this problem, I only see results for the problem opposite to that which I'm having. I need to plot zero values, not get rid of them. I am plotting logarithmic permeability (x-axis) vs. depth (y-axis). Apparently Excel cannot plot zeros on a log scale simply because the logarithm of zero is undefined (correct?). Here's my problem.