SOLVED

Chart two columns of data on the horizontal axis

Copper 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 (Copper 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

1 best response

Accepted Solutions
best response confirmed by John_John_Elwell45 (Copper Contributor)
Solution

@John_John_Elwell45 Something like in the attached file perhaps?

 

View solution in original post