This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 74%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
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:
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Hi,
I suggest you use Clustered Bar chart.
For example, if you add the "Start 2“and "Finish 2” 2 series, then you will get following chart.
The Finish2 bar is longer than Start2, if Finish2 is located on top of Start2, please right click on chart > Select Data > Reverse their order, click OK.
Right click on one bar > Format Data Series > Series Overlap: 100%. By the way, please change the Bounds values of X-axis.
And then, you will get following chart.
Please set the Start2 bar to white fill color and no border line.
Then please add the just Finish1 Series in chart via right clicking chart > Select Data > Add, add the data source. But you do not need add Start1, because the Start1 starts with 0:00.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hello,
This worked great, except now I have two data groups, a first era, and a second era. I want the graph to be able to stratify the two groups, ie, one group's cases on the top half of the graph, and then the second era's cases displayed on the bottom half of the graph. Each time I try to add the cases from the second era, they overlap. I have tried so far to just display the data in different cells to see if excel will see them as two separate groups, but so far to no avail.
Thank you so much for all of your tremendous help to us in this.
Image 1: Looks great! All we need now is for the data to be able to show the second group of cases:
Image 2: Once I add data from the second group of cases, it overlaps with all of the first ones, instead of taking their own places above or below.
Image 3: I have attempted moving the cases from the second era to a different part of the spreadsheet, but that did not work. For example: instead of taking data from era 2, from rows 85 and down, I instead moved everything below row 85 up onto a row equal with the first era of data- see below:
Thank you so much for you all's time and help in this!!!
I presume this is a follow-up question on https://learn.microsoft.com/en-us/answers/questions/2223399/how-to-display-time-duration-on-a-horizontal-bar-g
Don't really understand why you are now using a 100% stacked bar chart as that will indeed plot stacked bars from 0 to 1 (that is 0% to 100%). So if you have values like 0.15 and 0.45 these will be plotted as 25% [ 0.15 / (0.15+0.45) ] and 75% [ 0.45 / (0.15+0.45) ] for a total of 100%. That's how such charts work. You should use a regular stacked bar chart instead and you have two solutions in the linked thread.