SOLVED

Chart two columns of data on the horizontal axis

%3CLINGO-SUB%20id%3D%22lingo-sub-2650210%22%20slang%3D%22en-US%22%3EChart%20two%20columns%20of%20data%20on%20the%20horizontal%20axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2650210%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20download%20my%20blood%20pressure%20data%20from%20my%20monitor%20I%20get%20one%20column%20for%20dates%20and%20another%20column%20for%20times%20within%20each%20date.%20I'm%20trying%20to%20get%20a%20chart%20with%20data%20points%20for%20each%20date%20and%20time.%20I%20don't%20know%20to%20create%20a%20formula%20for%20the%20horizontal%20axis%20which%20combine%20column%20A%20(date)%20and%20Column%20B%20(Time).%20As%20an%20alternative%20how%20would%20I%20merge%20the%20data%20in%20columns%20A%20and%20B%3F%20I'd%20rather%20learn%20how%20to%20create%20a%20formula%20but%20any%20solution%20would%20be%20greatle%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2650210%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2650283%22%20slang%3D%22en-US%22%3ERe%3A%20Chart%20two%20columns%20of%20data%20on%20the%20horizontal%20axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2650283%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1128939%22%20target%3D%22_blank%22%3E%40John_John_Elwell45%3C%2FA%3E%26nbsp%3BSomething%20like%20in%20the%20attached%20file%20perhaps%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

When I download my blood pressure data from my monitor I get one column for dates and another column for times within each date. I'm trying to get a chart with data points for each date and time. I don't know to create a formula for the horizontal axis which combine column A (date) and Column B (Time). As an alternative how would I merge the data in columns A and B? I'd rather learn how to create a formula but any solution would be greatle appreciated.

2 Replies
best response confirmed by John_John_Elwell45 (New Contributor)
Solution

@John_John_Elwell45 Something like in the attached file perhaps?

 

@Riny_van_Eekelen 

 

That is precisely what I needed. Such a simple solution! I never would have discovered that on my own. I tried multiple complex solutions, none of which worked. Can't thank you enough!

 

Best regards, John Elwell