Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-18-2022, 08:22 AM
hehehehe hehehehe is offline How to change the date display Windows 10 How to change the date display Office 2021
Novice
How to change the date display
 
Join Date: Apr 2022
Posts: 3
hehehehe is on a distinguished road
Default How to change the date display

I have a excel file , the graph as attached .

as you can see the date ( year ) is 1900 , the data source is 2022 , I am strange that why the date is 1900 but not 2022 , I checked the locale is my local region .

May I know what is the reason it shows 1900 ?

Thanks
Attached Images
File Type: jpg 2022-04-12.jpg (57.9 KB, 23 views)
Reply With Quote
  #2  
Old 04-18-2022, 11:19 AM
ArviLaanemets ArviLaanemets is offline How to change the date display Windows 8 How to change the date display Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Haven't Excel available currently, but it looks like your graph gets 0 for your date value. Probably the date you have as source is really a text string - e.g. a result of FORMAT function. The numeric value of any text is 0.

About date and time. A date is really an integer, which presents the number of days from start of previous century. And time is a number, where Integer part of time value represents the number of full days (24 Hrs=1), and fraction part represents hours, minutes, and seconds. E.g. when you format a number 0.25 as time, you get 6:00:00.
Reply With Quote
  #3  
Old 04-18-2022, 04:53 PM
hehehehe hehehehe is offline How to change the date display Windows 10 How to change the date display Office 2021
Novice
How to change the date display
 
Join Date: Apr 2022
Posts: 3
hehehehe is on a distinguished road
Default

OK , may I know how to change the data source of the axis , so that it points to the date source ?

thanks
Reply With Quote
  #4  
Old 04-18-2022, 10:06 PM
ArviLaanemets ArviLaanemets is offline How to change the date display Windows 8 How to change the date display Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

I think you don't have a problem with axis of your graph, you have problem with dates in your source table!

Maybe you post your Excel file (with enough data for graph to be displayed) here.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change font color if date in column F is prior to today's date. kevinbradley57 Excel Programming 1 12-05-2018 07:35 PM
How to change the date display Selecting a Date in Date Picker and Having it change dates throughout joshuaran Word VBA 2 03-14-2018 09:24 PM
Day date and time cell display markg2 Excel 2 02-11-2015 06:57 AM
Milestones: Display of - turning off the display of the date Pmacdaddy Project 3 01-18-2013 05:42 PM
How to change the date display Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft