I'm using Excel 2016 and I am working on a date chart. The minimum bound is 1/1/2006, the maximum bound is set to 1/1/2017, and the major and minor units are set to one year each. The ranges and intervals of the chart work as intended (my data points do not actually fall on the first day of each year, but the vertical lines are spaced on those dates correctly). However, the x-axis labels all say "1/1/" and then the year. For example: 1/1/2006, 1/1/2007, 1/1/2008, 1/1/2009, 1/1/2010, 1/1/2011, etc. up to 1/1/2017. Is there a way to make the graph cleaner by chopping off the "1/1/" since it's pretty obvious that the vertical line represents the first of each year?