Forum Discussion

suhitm's avatar
suhitm
Copper Contributor
Dec 16, 2023
Solved

Chart reading dates incorrectly in Excel

Hello Community Members, the chart in Excel (Office 365) shows the date as January instead of March even though I've checked the regional date and time settings from the control panel.  I've also ch...
Charting
office 365
  • HansVogelaar's avatar
    HansVogelaar
    Dec 16, 2023

    suhitm 

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

suhitm's avatar
suhitm
Copper Contributor
Dec 17, 2023
Do you want a screen recording of this? Please reply so that I get to know if you need one in order to resolve the issue.
HansVogelaar's avatar
HansVogelaar
MVP
Dec 17, 2023

suhitm 

No, I'd like to be able to download a copy of the workbook so that I (and others) can investigate it directly.

  • suhitm's avatar
    suhitm
    Copper Contributor
    Dec 18, 2023

    HansVogelaar Ok I'll attach one with this reply 

     

    Here's the link https://1drv.ms/x/s!ArEZUq9YptFvmAhqN1A4CmHuWAFS?e=ZIaegJ

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Dec 18, 2023

      suhitm 

      Thanks!

      Click on the chart, then double-click the x-axis.

      Alternatively, select the x-axis, then activate the Format tab of the ribbon and click Format Selection.

      In the Format Axis task pane, under Axis Options, select Text Axis as Axis Type.

      The axis labels will then be the same as the cell values.

      • suhitm's avatar
        suhitm
        Copper Contributor
        Dec 18, 2023

        HansVogelaar thanks buddy for the help.

         

Resources