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
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
How to change the date display
0
Answers
0
Hi and welcome to the Forum.
In Excel dates are stored as serial numbers, beginning 01 January 1990. See Don's tutorial here: Dates in Excel Explained
Hope this helps. (Incidentally we cannot see your graph, this Forum allows you to attach only Excel files so we cannot see the image you tried to include in your question.)
Discussion
I could not upload file .
OK , may I know how to change the data source of the axis , so that it points to the date source ?
thanks
hehehe Apr 18, '22 at 7:54 pm
To upload a file, please edit your original question and use the Add Files.. button below the textbox.
John_Ru (rep: 6142) Apr 19, '22 at 4:38 am