I do not work with pivot tables or pivot charts very much. The problem seems to be the way that Excel handles the multi-level category axis when most of the different category levels are in the same column. In a non-pivot table/chart, I would have expected the categories to be arranged:
where there are four columns for each part of the date. I don't know how pivot table/charts are expected to handle the same kind of thing, so I cannot make suggestions in that regard, and, as Sandy noted, we cannot change the pivot table because the pivots source is blocked. If I were to move forward with this, the direction I would probably try is to see if I could coax the pivot table to list year, month, day, time as separate column rather than have month/day in the same column.
Bookmarks