7 Replies Latest reply on May 22, 2017 11:59 AM by Michael Lahey

    Overlapping Bar Chart

    Michael Lahey

      I have a dataset that has items that have a start date, end date, forecasted date, and type. I am trying to get the average duration for items that make the forecast versus the average duration for items that miss the forecast. I would like these to be in a single bar so that each type is a single bar and the make and miss don't sum with each other. I have attached a packaged workbook with sample data and the 3 ways I have done it that aren't what I'm looking for. I was hoping that dual axis would work on the last sheet but it is not an option. Does anyone know if this is possible?