Single Custom X-Axis Label (Date) in Excel Chart

sam007

New Member
Joined
Jun 12, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
I'm trying to edit a single label on the X-axis of my Excel chart. I have a simple time series chart with date labels on the x-axis. I have chosen a single letter for the month. I want to edit the first month of the year (J) only and change it to 2020. The next label should remain F.

I attached a screenshot of what the X-axis labels should look like. With one label the year and the rest of the labels the month.
 

Attachments

  • Template.jpg
    Template.jpg
    201.3 KB · Views: 8

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,118,361
Messages
5,571,726
Members
412,415
Latest member
NitinPanjwani
Top