X-axis labels (Date) in Excel Chart

Copper Contributor

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 copy of the Excel file and a screenshot of what the X-axis labels should look like.


1 Reply

Hi @Sam_S007 


Hope you are doing well. 


I would like to mention a No Code Data Visualization add-in for the requirement you mentioned. You can play while you are making data for chart. You have to select "Sentiment Trend Chart" from "Sentiment Analysis Charts" section. A detail video and sample sheet contains chart and data is there for help purpose. 


You can check here for Microsoft Excel & Office 365.


And if you are comfortable with Google Sheets, you can find here.