#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
OK , may I know how to change the data source of the axis , so that it points to the date source ?
thanks |
#4
|
|||
|
|||
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. |
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 |
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 |
Imported message date change to today's date | promark | Outlook | 1 | 12-23-2005 07:21 AM |