Forum Discussion
Solved
chart
Hello, concerning making a chart of data recorded over time : datum time parameter ( in casu % CO2) when i make a chart : date & time in horizontal axis parameter in vertical axis ti...
this works !
just curious ; another option could be to merge the 2 cells but when I try to merge cell A2 with date content 11-19-2021 and cell B2 with time content 12:00:00 into cell C2 with formula =A2&" "&B2 I get 44519 0.5
how can I resolve this ?
In Excel dates are integer numbers and time is decimal part of numbers. Thus more correct will be to use =A2+B2 which gives 44519.05. If apply datetime format to it returns
I didn't play with the chart for such combination, perhaps you need to use scatter chart and apply proper format to x-axis.
that (=A2+B2) also works; thanks for the solutions !
Stefaan_DM , glad to help