title: Excel Chart - Offset (Start from non-zero)
body: <p>Having some trouble with properly representing data in a chart in excel 2007.</p>
  
  <p>Basic Concept (A daily process):
  Files arrive in batch automatically in a folder for processing. The file time in the table is the time the last file arrived. Processing is done on the files as indicated by the start and end time under processing.</p>
  
  <p>The processing can begin on files before the last file for the day arrives. In this case the start processing time would be less then file arrival time. There is an overlap in arrival durations and processing.</p>
  
  <p>Problem: How do I get excel to show the red bar (processing times) to start from (lets say for the 21st Feb) 3:46 to 3:59 (all times in 24hr format)</p>
  
  <p>I don't want stack chart because I can't represent gaps or overlaps between different stages effectively. </p>
  
  <p><img src="https://i.stack.imgur.com/E14FN.jpg" alt="enter image description here"></p>
  
  <p>One possible solution I been trying was to display the duration of the processing time and then offset that duration by the start time (where start time is taken from 00:00 hours). However excel insists on starting the bars from 00:00</p>
  
  <p>Thanks</p>