When using a PivotTable where one of the fields is a date in either the rows or columns, Excel treats each day as its own row or column. It would be very useful to be able to group the dates and have Excel summarize the data by month, quarter, or year in the PivotTable.1 vote
Kenneth’s comment (that you can do this by selecting and then grouping dates) is right on.
Further, in Excel 2016 and later, when you create a Pivot with a Date field, Excel will automatically group for you. In that case, if you want to go back to the previous behavior, you can by following the instructions here:
The gridlines are always light gray on white or white on gray. Its maddening that you cant see them. Its also one pixel wide. GIVE ME A SETTING for color. I want a black gridline not gray. I also want a setting for width.1 vote
Turns out you can do this already – Just head into File | Options | Advanced | Display options for this worksheet and then choose the gridline color.
Hope that helps,
Allow clipart to be used in bar charts. For example a chart showing sales of motorcycles and automobiles could use appropriate icons and a value could be set where 1 graphic = x units.1 vote
- Don't see your idea?