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! Jul 31 '18 at 20:05
  • @PeterBentley yeah, pretty much yes :)
    – user0
    Jul 31 '18 at 20:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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