I have two columns in a spreadsheet: A1:A100 has start times, and B1:B100 has duration. I am trying to create a chart that looks something like this, where each row gets a vertical line placed at the relevant start time (column A in the sheet) and the length of the vertical line is determined by the duration (column B in the sheet). Can it be done? I'm relatively new to this and I've tried column charts, waterfall, and scatter, but none seem to be working out very well.

Gantt-like time chart with start times and durations


not really, but it can be built (based on the sheet you provided):


  • Wow, this is pretty amazing. Do I understand this correctly? You basically create a formula which checks to see whether each cell should be colored or not based on the transposed sheet. Is that right? Pretty cool! – Peter Bentley Jul 31 '18 at 20:05
  • @PeterBentley yeah, pretty much yes :) – MARK MY ANSWER Jul 31 '18 at 20:06

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.