Excel dates and times

Copper Contributor

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?

9 Replies

@E_O_MastinOlin 

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

@Hans Vogelaar 

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

@E_O_MastinOlin  OK I got it.  It was a matter of selecting the data.

@E_O_MastinOlin 

But how can I get closer intervals?

@E_O_MastinOlin 

Ok but now how can I get closer intervals?

@E_O_MastinOlin 

What do you mean by that?

@Hans Vogelaar 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 

There are to problems:

1) The interval between x-axis labels has been set to 5. Change it to 1.

S0049.png

2) You display Primary Minor Vertical gridlines. Turn those off and display Primary Major Vertical gridlines.

S0050.png

@Hans Vogelaar  Got it. Thanks!