How to Get Horizontal Bar Graph to Realign with Data

Question

Hello,

I am trying to display data on a horizontal bar graph showing surgery duration and times, I have each time labeled as "start 2" and "finish 2" for the starting and finishing times, expressed in number format (1 being 24 hours, or 0:00, 0.5 being 12 noon). I also have "start 1" and "finish 1" for overlapping times that continued beyond midnight, in order to display surgical times restarting at 0:00 on the left side of the graph (the graph axis moved from midnight to midnight). The following pictures should clarify.

My problem is that the times, as seen in the pictures (bars are labeled with their correct corresponding value, for clarity), is that the values for each bar (which are correctly labeled) do not line up with the x-axis. So, for example, 0.4 is shown on the graph more around 0.35, and "1" will go off the graph and end about at 2.8 or so. Can someone please clarify how to get the data to just line up with the x-axis?

Other context: this is a 100% stacked bar chart.

I have tried:

• manually setting the axis minimum and maximum values
• changing the axis to display values in reverse order
• adjusting the bar width
• ensuring data is mapped to the correct axis ("primary axis")
• ensuring the number format of the cells the data is coming from is "number" instead of "text."

Also included among these pictures are the formulas I used, just for context (don't worry about it).

If this works correctly, the blue bars, "finish 2" should not all move out to "1," instead, most should stop before reaching 1 because their values are, as indicated, less than 1.