Calculating a slope by the function and graph on a semi-log graph
Feb 22, 2014 · Re: Calculating a slope by the function and graph on a semi-log graph Please find attached the pic of the graph. The base of the log used in the plot is 10, but the slope in the equ. is -33074 not 14364!
How to plot semi log graph in Excel? - Excel Help Forum
Apr 10, 2006 · Double click the y-axis, then from the Scale tab select 'Logarithmic scale' To create custom "gridlines" see ...
How to plot semilog graph with data? - Excel Help Forum
Jul 21, 2012 · Hello Everybody, This is my first post in this forum. i am newbie to excel. I have a semi-log graph data first column X axis data and the second column is its corresponding Y data. The data sheet is given here . Now i want to plot a semi-log graph using these data. But i cant do it due to lack of my knowledge in excel.
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 …
can I draw a semi log graph using exel 2000? [SOLVED] - Excel …
Mar 13, 2006 · You will have a graph with a logarithmic x-axis and linear y-axis (semi-log). Incidentally, Excel will point out to you (over and over again!) if any logarthimically-plotted values are zero or negative, or if the minimum of the axis scale is set to zero or below. "sara" wrote: > can I draw a semi log graph using exel 2000?
how do i change the x-axis of a graph to a log scale? - Excel Help …
Apr 13, 2006 · Anne: Double click any value on your x axis, this will bring up Axis format form. Select scale tab, check Logarithmic checkbox.
Plotting Zero Values (Logarithmic Scatter Plot) - Excel Help Forum
Oct 30, 2013 · 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. Not only does permeability vary over several orders of magnitude, but it often has a value of zero (or effectively zero).
need a formula for interpolation on a semi-log graph - Excel Help …
Oct 3, 2013 · need a formula for interpolation on a semi-log graph I am looking for some help on a formula to find the sieve size that goes with 50% passing (median particle size). Percent passing is on the y-axis and sieve size is on the x-axis.
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.
Create semi-log plot for percentage - Excel Help Forum
Dec 21, 2005 · I have exhausted myself searching the internet for a way to create this graph. I am really hoping that someone on this forum will help me. 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.