Forum Discussion

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
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?

HansVogelaar

MVP

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

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
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
  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
  Sample Sheet.xlsx16 KB
  - 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.