The X-axis, which is the horizontal axis, on most Excel charts does not use numeric intervals like the vertical Y-axis does. The X-axis contains either strings of text or a date under each set of data ...
Double-click the chart's left axis to open the Format Axis side panel. Click "Axis Value" to allow manual control over the axis. Enter the number you wish to use for the axis in the field provided. To ...