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".