Other versions of Excel
- In your XY (scatter) graph, double-click the scale of each axis.
- In the Format Axis box, select the Scale tab, and then check Logarithmic scale.
To convert from logarithmic scale to linear scale, raise the base, value of 10, to the power of each x- and y- data point. The first ordered pair would be 10 raised to the first and second powers, producing values of 10 and 100, such that the ordered pair in linear scale is (10, 100).
On a linear scale the value between any two points will never change. A logarithm is based on exponents, which are the superscripts next to, and above, another base number or variable. On a logarithmic scale the value between two points changes in a particular pattern.
A log-linear model is a mathematical model that takes the form of a function whose logarithm equals a linear combination of the parameters of the model, which makes it possible to apply (possibly multivariate) linear regression.
A logarithmic scale is a nonlinear scale, typically used to display a large range of positive multiples of some quantity, ranging through several orders of magnitude, so that the value at higher end of the range is many times the value at the lower end of the range.
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.
A logarithmic scale is defined as one where the units on an axis are powers, or logarithms, of a base number, usually 10. When comparing two y values on a logarithmic scale, subtract the second logarithm from the first, and then raise the base to the resulting number to get the actual ratio between the two numbers.
An exponential function or curve is a function that grows exponentially, or grows at an increasingly larger rate as you pick larger values of x, and usually takes the form. , where is any real number.
The logarithm, or log, is the inverse of the mathematical operation of exponentiation. This means that the log of a number is the number that a fixed base has to be raised to in order to yield the number. Conventionally, log implies that base 10 is being used, though the base can technically be anything.
A logarithmic price scale is a type of scale used on a chart that is plotted such that two equivalent price changes are represented by the same vertical distance on the scale. The distance between the numbers on the scale decreases as the price of the asset increases.
A log-linear (sometimes log-lin) plot has the logarithmic scale on the y-axis, and a linear scale on the x-axis; a linear-log (sometimes lin-log) is the opposite. It is equivalent to converting the y values (or x values) to their log, and plotting the data on linear scales.
A linear price scale is plotted on the y-axis—vertical—side of the chart. There is an equal distance between the listed prices. Also, each unit of a price change on the chart is represented by the same vertical distance—or movement up—the scale, regardless of what the asset's price level when the change happened.
Logarithms and logarithmic scaling are tools that you want to use in your Excel charts because they enable you to do something very powerful. With logarithmic scaling of your value axis, you can compare the relative change (not the absolute change) in data series values.
Logarithms are a way of showing how big a number is in terms of how many times you have to multiply a certain number (called the base) to get it. The most common numbers to use are 2, 10, and 2.71828). Logarithms are useful because they are the way our brain naturally understands most things.
