Forum Discussion
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
time is put vertically but not the date : how can i fix this ?
I tried to put date and time next to each other in one cell but then it changes in numbers
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 ?
5 Replies
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.
