I have some data in three columns that I am having problems plotting. The first column is the date, the second is time, and the third is the data value.
I need to chart this with Date AND time as the x-axis since the data is over a span of several days but canot figure out how to combine the date column value and the time column value into one value to use on the x-axis.
Can this be done or will I be relegated to dividing the data by days and print out over 10+ charts for the 10+ days the data was collected?
Any assistance will be appreciated, I have not found a function that lets me concatenate these values into a functioning number
Working with “date” and “time” can be done in so many variants and cause so many unexpected problems that you should surely attach an example sheet showing in detail what you have and what you tried.
If your DATEs and TOD values are both represented by numbers as usual with integers for the dates and numbers from 0 through 1 (<1) for the TOD values, you can simply add them in a new column which you use for the x-axis then.
disask99305xyChartOverDateTime.ods (24.1 KB)
1 Like
Here is the dile my data system sent back, unfortunately everything I have tried to get date together with Time has failed and resulted is false date numbers for my X-Axis
23314244_111223_145503.ods (27.9 KB)
I see now that all you have to do is add them, I was overcomplicating things by looking for a function
thanks for the help
Monitoring the acidity of a water outlet (alkaline in this case) is a serious task.
Therefore this disclaimer: I take no responsibility of any kind for what’s made of my suggestion. And: A spreadsheet may not be the right means at all.
BTW:
Never use or display only 2 digits to designate a year. Let’s hope there will be more than 100 years to come - and surely there were more than 100 that already passed. Even the “age of computing” may one day span more than 100 years.
Calendaric dates needing to be reliably transferable must be represented as texts regarding ISO 8601.
A date-time-stamp should not be composed in any way from independently supplied DATE and TOD. It should be one item. It should also contain complete information about its relation to UTC. What about “DST” shifts?
No big issues with monitoring responsibility, this is just used to plot the discharge curve and only as a backup source should other data be damaged. we are getting correct values in the spreadsheet it was just the need to concatenate the date and time together and the example you gave works and the x-axis data is good. We now do not have to separate it by days, instead we can plot a whole week of data in one chart and it matches the main device perfectly
thanks for the help with the x-axis values