#StackBounty: #google-sheets using dates with stacked bar chart

Bounty: 50

I’m trying to create a stacked bar chart to show the start and end times graphically. It works if I represent the times as numbers, but then on the X axis it is unclear what the numbers mean. For instance, if the intervals are in seconds it is difficult to mentally add that to the current time to figure out when the event starts and ends:

enter image description here

To be clear, the above chart does exactly what I want it to, except show the x-axis as date/time values.

But when I switch to using dates, the chart shows totally bogus values: each start time is shown extending from 1900-01-01 00:00:00 to approximately the current year (some time between 2000-01-01 and 2050-01-01) and the end show up as some time close to 2150.
enter image description here

If on the other hand, I use the start as a date and an additional duration (expecting that perhaps sheets is internally converting the date into something like an Epoch seconds count) it no longer shows a date, and still shows non-sensical results (to me) with everything apparently starting at the same time, past forty some thousand:
enter image description here
I tried editing the chart, looking for some way to set the formatting and range of the X axis. I found that when the axis was a number I could set a minimum and maximum, but when the X axis was a date this option disappeared (although it seemed to be retained at least partially because the part of the date was omitted). But still, why in chart 2 does it show all charts starting and ending at the same points, when they shouldn’t?

Get this bounty!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.