Hello everyone,
I'm trying to plot time series. I combined date column and time column to have both in each cell. Now when I choose the scatter plot it just shows the numbers instead of date. I tried several things such as changing the format before (number or text) and after plotting and (custom) and ...
The only way that worked is choosing each cell and push enter bottom, then it changes the appearance a little and shows that properly but I can't do this for 36000 line of data
Would you please help me with this problem?
Thanks.