Establish Chart Log For Free

To create a log-log chart in Excel: Select the data that you want to plot. Click the Insert tab, and then click Scatter. Click Scatter with only Markers. Click OK. Right-click the x-axis, and then click Format Axis. Under Axis Type, click Logarithmic scale. Click OK. Right-click the y-axis, and then click Format Axis.

If Y = log(y) and X = log(x) then Y = nX. This shows the linear relationship. Plotting Y against X, i.e., log(y) against log(x), leads to a straight line as shown below. (a) a (b) b (c) c (d) d Note that the scales on the two axes are not the same.

On a logarithmic scale, numbers on the Y-axis don't move up in equal increments but instead each interval increases by a set factor ? it's often 10 but could be a factor of 3 or 350 or 3,500, anything at all. It all depends on what is deemed to be the most effective way of interpreting the data in question.

10 log scale is used for the Y axis of the bottom left graph, and the Y axis ranges from 0.1 to 1,000. The top right graph uses a log10 scale for just the X axis, and the bottom right graph uses a log10 scale for both the X axis and the Y axis.

A logarithmic scale shows exponential growth on a graph. It's a nonlinear scale that's frequently used for analyzing a large range of quantities compactly. It is extremely useful when graphing a large variance in data.

There are two main reasons to use logarithmic scales in charts and graphs. The first is to respond to skewness towards large values; i.e., cases in which one or a few points are much larger than the bulk of the data. The second is to show percent change or multiplicative factors.

You typically use a logarithmic scale for two reasons. The first reason is when large values skew the graph of the data, and the second is to show multiplicative factors or percent changes. Many careers use logarithmic scales, from farmers to researchers.