Excel dates and times

%3CLINGO-SUB%20id%3D%22lingo-sub-2090009%22%20slang%3D%22en-US%22%3EExcel%20dates%20and%20times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2090009%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20get%20the%20date%20and%20time%20to%20display%20of%20each%20entry%20under%20the%20chart%20on%20the%20horizontal%20axis%20corresponding%20to%20each%20entry%20of%20the%20vertical%20axis%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2090009%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2090073%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20dates%20and%20times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2090073%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F940105%22%20target%3D%22_blank%22%3E%40E_O_MastinOlin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDoes%20it%20help%20if%20you%20double-click%20the%20horizontal%20axis%20and%20select%20'Text%20axis'%20as%20'Axis%20type'%20in%20'Axis%20options'%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2090180%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20dates%20and%20times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2090180%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethat%20did%20help%20but%20the%20year%20is%20wrong.%26nbsp%3B%20It%20has%201900!%26nbsp%3B%20How%20do%20I%20get%20it%20to%20be%202021%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2090190%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20dates%20and%20times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2090190%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F940105%22%20target%3D%22_blank%22%3E%40E_O_MastinOlin%3C%2FA%3E%26nbsp%3B%20OK%20I%20got%20it.%26nbsp%3B%20It%20was%20a%20matter%20of%20selecting%20the%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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!