This seems like it should be a simple request, but I cannot get pivot tables and the resulting charts to handle it.
I have a log of events with date stamps. I simply want to show the number of events by day over a date range, including dates with no data (to properly show a trend).
I created a pivot table, with the date-time stamp as the row. Excel groups them into days (good), but with the format "23-Nov, 24-Nov, etc.", and if the date stamps cross a year, the next year's dates (1-Jan, 2-Jan, etc.) don't sort properly (they appear first in the sort). If I try to add year to the grouping, Excel crashes. This is on the latest Office 365.
There has to be a simple way to do this, I can't be the first to have this need.
Thanks for your help.
Bookmarks