Create Hybrid Gantt Chart

  • Hi,

    I am hybrid Gantt chart of sorts. I'll try to explain what I mean by that . Let's say I have the following test data that I'm working with:

    Test Name Start Date Duration
    Test 1 1/1/2021 10
    Test 2 1/5/2021 17
    Test 3 1/10/2021 12
    Test 4 1/17/2021
    Test 5 1/24/2021 19
    Test 6 2/3/2021 14
    Test 7 2/17/2021

    What I want to do is create a hybrid Gantt chart where the tests which have a start date and duration are represented by bars and the tests which only have start dates (meaning they have not completed) are represented by a symbol. I have created the basic Gantt chart structure by creating a stacked bar chart with the test name on the vertical axis and the start date and duration on the horizontal axis with the date set to no fill. I then created a new data series where the tests with durations are represented by N/A and the dates without durations are the start dates. But this is where it stopped working for me...When I first added the new data series, it displayed the data as bars going from the start data and extending all the way to the max value of the date axis. When I tried to change the chart type for the data series to a line chart with data markers, it added a second vertical axis where that axis is all dates. Can anyone help me???

  • Hello,

    As you probably already know it, there are thousands of available templates when it comes to using Gantt in Excel ....:)

    So, it would be wise to search for the most convenient solution for you ... and, if, on top of it, you do need some fine-tuning, post back your precise requirement ... ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)