Forum Discussion
Manual start value time x-axis
I have several column charts with time (ie the column is data type time, not date time) in hourly bins on the x-axis (the times are several years of meeting start times). Basically, the charts show t...
I suspect it is a bit buggy. I have a calc column set to time that will only display as date/time on the x axis. Could you convert/format the time as a decimal number instead?
MattAllington wrote:Could you convert/format the time as a decimal number instead?
This lets me enter a start value, but causes the graphs to show difficult to interpret axis labels. I set the data type to decimal number. This allows me to set a start time across each chart, but it appears as 0.25 which is meaningless (I want it to say 06:00). When I set the data type back to time, the value I entered as '0.25' changes to "01/01/1970 10:00:00 am", and causes the graph to show nothing.