I suspect the space allotted for each label isn't quite long enough, so the
last character is truncated. I know all digits are the same width, but
sometimes, especially when the font size is small, "1" is narrower than the
rest, which explains why it isn't truncated.

Could you make the chart wider, or reduce the number of labels (increase the
major spacing)?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Matt McQueen" wrote in message
...
I have an area chart that plots quarterly data. I want to show only years
on
the x-axis, so I changed the interval to 1 year and the number format to
'Custom yyyy'. However this is shortening my dates, so 2020 becomes 202.
Bizarrely, 2021 and 2031 show up in full, but other dates are only shown
by
their first three digits.

Any ideas?