Create a Gantt from pivot table - in Power Pivot - is it possible ? RRS feed

  • Question

  • hi to all , I try to create a GANTT out of PivotTable , the problem is that the basis for the construction of the GANTT is a simple table that contains topics execution dates and times, and I have a PivotTable , is it possible to get around the obstacle? Many thanks.

    yaniv012 from M.S.

    Monday, March 9, 2015 3:15 PM


  • Hi yaniv012,

    According to your description, you want to create a Gantt chart based on your simple table in power pivot. Right?

    In PowerPivot, there's no limitation to say the GANTT chart should be based on pivot table. In this scenario, since your simple table already have the start date, end date and duration, you can create the GANTT chart based on this simple chart.

    Dynamic Gantt charts in excel 2007
    Project followup with Gantt charts in excel

    If you have any question, please feel free to ask.

    Best Regards,

    Simon Hou
    TechNet Community Support

    Tuesday, March 10, 2015 1:57 PM