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?
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.
There are to problems:
1) The interval between x-axis labels has been set to 5. Change it to 1.
2) You display Primary Minor Vertical gridlines. Turn those off and display Primary Major Vertical gridlines.
