Forum Discussion
Excel dates and times
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?
Does it help if you double-click the horizontal axis and select 'Text axis' as 'Axis type' in 'Axis options'?
that did help but the year is wrong. It has 1900! How do I get it to be 2021?
Ok but now how can I get closer intervals?
What do you mean by that?
HansVogelaar I'll try to explain. The dates are far apart. I would like the dates to correspond to each daily entry. I attached the file but you have to look at the "Blood Pressure Chart " to see what I mean.
E_O_MastinOlin OK I got it. It was a matter of selecting the data.
But how can I get closer intervals?