February 18, 2017
i am trying to create a bar chart from a pivot table with information from a recently built building. The leasing started in June 2016 and went through Feb 2017. For some reason when you group by months, the pivot table takes the jan and feb 17 and puts them ahead of june-beyond 2016. It's as though it's not associating the dates with their year. I tried grouping by months and years but then you can't build a chart from that information because there are rows for "2017".
June 25, 2016
April 5, 2018
July 16, 2010
I don't know of a way to make a Gantt chart from a PivotTable but these tutorials may help: