Impressive Excel X Axis Scale

To create a column chart execute the following steps.

Excel x axis scale. If the Base Unit of the axis scale is set to days you would see slight differences in the spacing between months. Make sure the Axis Options icon is chosen on the top see picture Choose Logarithmic scale. That of course is absurd as the x axis is also very frequently used to represent time in my case Im documenting sessions and want my.

Start date Jul 1 2004. The problem is that Excel is plotting these figures evenly spaced. Excel X-axis scale spacing.

You have to use a scatter XY chart to be able to make the X-axis logarithmic. The easy way to make the adjustment to a completed chart is to right-click on the target axis and that displays a screen with Format Axis see screenshot. Select this type of chart adjust each series as set second series on secondary axis double click on X-axis and set min max and interval.

Heres how to change the x-axis to logarithmic in Excel. However the x axis is a time scale in format hhmmss000 which I have converted into ss ranging from 0 sec - 0 sec corresponding to 100. I have many points over a short range but other points also far from that range.

I expected the max to be set to 60 not 00008. In Excel 2013 you can change the scale of axis in a chart with following steps. In this case its better to use scatter chart.

1 In Excel 2013s Format Axis pane go to the Axis Options tab check the Axis value option in the Horizontal axis crosses section and enter the minimum value of Y axis in the following box. The trick is to create a common scale so that the primary and secondary axis start and end at the same point. This example teaches you how to change the axis type add axis titles and how to change the scale of the vertical axis.