Forum Discussion
chart
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 ?
Please try to uncheck this setting for horizontal axis
If it checked (default) axis will be as at the bottom chart.
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 !