Forum Discussion
John_John_Elwell45
Aug 15, 2021Copper Contributor
Chart two columns of data on the horizontal axis
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.
John_John_Elwell45 Something like in the attached file perhaps?
2 Replies
- Riny_van_EekelenPlatinum Contributor
- John_John_Elwell45Copper Contributor
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