View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Matt McQueen Matt McQueen is offline
external usenet poster
 
Posts: 23
Default Area chart date format

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?