X-axis labels (Date) in Excel Chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1821239%22%20slang%3D%22en-US%22%3EX-axis%20labels%20(Date)%20in%20Excel%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1821239%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20edit%20a%20single%20label%20on%20the%20X-axis%20of%20my%20Excel%20chart.%26nbsp%3B%20I%20have%20a%20simple%20time%20series%20chart%20with%20date%20labels%20on%20the%20x-axis.%20I%20have%20chosen%20a%20single%20letter%20for%20the%20month.%26nbsp%3B%20I%20want%20to%20edit%20the%20first%20month%20of%20the%20year%20(J)%20only%20and%20change%20it%20to%202020.%20The%20next%20label%20should%20remain%20F.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20a%20copy%20of%20the%20Excel%20file%20and%20a%20screenshot%20of%20what%20the%20X-axis%20labels%20should%20look%20like.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1821239%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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.

 

Thanks