Forum Discussion

Sam_S007's avatar
Sam_S007
Copper Contributor
Oct 26, 2020

X-axis labels (Date) in Excel Chart

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.

 

office 365
  • Qaiser_j's avatar
    Qaiser_j
    Brass Contributor
    Aug 31, 2021

    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  

Resources