title: Dynamic Gantt Chart in Excel
body: <p>I am following this link to create my Gantt Chart in excel. <a href="https://www.officetimeline.com/gantt-chart-excel" rel="nofollow noreferrer">https://www.officetimeline.com/gantt-chart-excel</a></p>
  
  <p>Everything works fine, but I am trying to create this chart dynamically by using a pivot table. Let me explain. The pivot table has the values that are needed for the charge, but it does also have 1 value that will be use as a filter, doing this, I should be able to create a gantt chart for A or B, or A and B. </p>
  
  <p>The challenging that I am facing is that if A has 200 task, and B only 10, the chart is taking all the "200" lines instead of only the ones that contains data. I looked everywhere and couldnt find a way to "skip" empty cells. Any idea?</p>