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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,118,415
Messages
5,571,977
Members
412,430
Latest member
Huuktkt
Top