The option to use a logarithmic scale depends on the chart type: you won't see that option for the x scale if, e.g., you've selected "column" or 28 Nov 2014 An arithmetic scale shows equal spacing between the chart units. In the example below, horizontal lines are spaced every 5 Dollars and they and arithmetic chart scale can be seen on the vertical axis, which is the y axis. You have to use a scatter (XY) chart to be able to make the X-axis logarithmic. It is the only chart type with a numeric X-axis instead of a category X-axis. --- However, you can customize the scale to better meet your needs. For example, if all the data points in your data table are between 60 and 90, you might want the value (y) axis to have a range of 50 to 100 instead of 0 to 100. When a value axis covers a very large range, you can also change the axis to a logarithmic scale (also known as log scale). Because the scale of the line chart's horizontal (category) axis cannot be changed as much as the scale of the vertical (value) axis that is used in the xy (scatter) chart, consider using an xy (scatter) chart instead of a line chart if you have to change the scaling of that axis, or display it as a logarithmic scale.
On the chart, right-click the Y axis, so you see Format Axis in the context menu. Select that. Under Axis Options you'll have options for Bounds, Logarithmic Scale, and a bunch of other stuff. Something in there will do your bidding. Hi, I've created a line chart (dates on x-axis and values on y-axis) and have selected to represent the y-axis values on a logarithmic scale. The value labels on the y-axis are now 10, 100 and 1000. Is it possible, for presentation purposes, to change the values on the y-axis? (I have tried altering those in the Format Axis box, but with no success) Thanks!
You can use the logarithmic scale (log scale) in the Format Axis dialogue box to scale your chart by a base of 10. What this does is it multiplies the vertical axis When I format the x-axis to use a logarithmic scale, the y-axis is displayed on the right side of the graph instead of the left side of the graph like it is supposed to 7 Apr 2019 Check the box marked Logarithmic scale. You get base 10 by default, but your data may look better on the chart if you choose a differen Note: The X-axis of a Mekko chart is also a value axis. Set Logarithmic/Linear Scale: Set the axis to a logarithmic or linear scale (see Logarithmic Scale). As you can see the Y axis is clearly log scale. However, there is an Excel gotcha here. The X-axes for most chart types (apart from Scatter) are Hello, I have found that I can format the Y Axis to be logarithmic but there are fewer scale options for the X Axis. I am trying to use Frequency for You can customize the axis scale, or range, to make your chart easier to understand. You can specify A logarithmic scale in Reporting shows the base value of 10 raised to the power of a value. Select the Y-axis or the X-axis of the chart.
When I format the x-axis to use a logarithmic scale, the y-axis is displayed on the right side of the graph instead of the left side of the graph like it is supposed to 7 Apr 2019 Check the box marked Logarithmic scale. You get base 10 by default, but your data may look better on the chart if you choose a differen Note: The X-axis of a Mekko chart is also a value axis. Set Logarithmic/Linear Scale: Set the axis to a logarithmic or linear scale (see Logarithmic Scale). As you can see the Y axis is clearly log scale. However, there is an Excel gotcha here. The X-axes for most chart types (apart from Scatter) are Hello, I have found that I can format the Y Axis to be logarithmic but there are fewer scale options for the X Axis. I am trying to use Frequency for
When I format the x-axis to use a logarithmic scale, the y-axis is displayed on the right side of the graph instead of the left side of the graph like it is supposed to 7 Apr 2019 Check the box marked Logarithmic scale. You get base 10 by default, but your data may look better on the chart if you choose a differen Note: The X-axis of a Mekko chart is also a value axis. Set Logarithmic/Linear Scale: Set the axis to a logarithmic or linear scale (see Logarithmic Scale). As you can see the Y axis is clearly log scale. However, there is an Excel gotcha here. The X-axes for most chart types (apart from Scatter) are Hello, I have found that I can format the Y Axis to be logarithmic but there are fewer scale options for the X Axis. I am trying to use Frequency for You can customize the axis scale, or range, to make your chart easier to understand. You can specify A logarithmic scale in Reporting shows the base value of 10 raised to the power of a value. Select the Y-axis or the X-axis of the chart.