Hi everyone,

To explain my problem: I need to create a timeline in excel for data that can be dynamically changed leading to a different number of items in the timeline as well as a different range of dates.

My issue is that with a basic gantt chart I will have some bars be empty, but the chart does not automatically resize to not include these values so there is a large gap vertically. Another issue that goes along with the chart's data being dynamic is that the dates on the y-axis don't automatically resize when the time is changed.

Any help would be much appreciated!