Ticks refer to both inner ticks and outer ticks. Right click the axis you will change data format, and select Format Axis from right-clicking menu. Go ahead based on your Microsoft Excel version: (1) In Excel 2013's Format Axis pane, expand the Number group on the Axis Options tab, enter m/d or mmm or others into the Format Code box and click the Add button. Axis Colors and Ticks StylesВ¶. The color of the axis, the color and length of your tick marks and the font and color of your labels can be specified as follows.

To fix, just switch units to something else, then back again to 1 year.So, now we can see some other problems. Then enter yyyy.That gives us years on the axis, but notice this somehow confuses the Unit settings. Just select custom, under Number. I'll undo that.To illustrate how this works, let me create another chart with a smaller set of the same data, but only include 1 year.Now when I check the axis settings for the horizontal axis, notice that units are now set to months, to better fit this range of data.Back in the first chart, let's clean things up on the horizontal axis.First, I'll change the labels to years using number formatting. With the vertical axis selected, we see value axis settings.When I select the horizontal axis, we see category axis settings.Both value and category axes have settings grouped in 4 areas: Axis options, Tick marks, Labels, and Number.The axis type is set to automatic, but we can see that it defaults to dates, based on the bounds and units Excel has set as defaults.Notice bounds have been set automatically based on the 5-year date range, and units are set to years.If I temporarily switch to text, things change dramatically.

Format Vertical Axis Excel For Mac