Excel dates and times

Question

How do I get the date and time to display of each entry under the chart on the horizontal axis corresponding to each entry of the vertical axis?

hansvogelaar · Answer

E_O_MastinOlin&nbsp;
Does it help if you double-click the horizontal axis and select 'Text axis' as 'Axis type' in 'Axis options'?

e_o_mastinolin · Answer

HansVogelaar&nbsp;that did help but the year is wrong.&nbsp; It has 1900!&nbsp; How do I get it to be 2021?

e_o_mastinolin · Answer

E_O_MastinOlin&nbsp; OK I got it.&nbsp; It was a matter of selecting the data.

e_o_mastinolin · Answer

E_O_MastinOlin&nbsp;But how can I get closer intervals?

e_o_mastinolin · Answer

E_O_MastinOlin&nbsp;Ok but now how can I get closer intervals?

Forum Discussion