View Single Post
 
Old 04-18-2022, 11:19 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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