I have a report series for monthly injuries reported at all my company's locations. I filter by location and display the injury types and the number of each, as per the sample workbook attached. From this, a pie chart is built for each location.
The problem is that there are always so many one-shot injury types (we encourage reporting of every single incident, no matter how minor) that an automatic pie chart invariably includes so many tiny slivers that the chart is impossible to read. I've been manually summing the single incidents, copying it and the rest of the injury data to another location in the worksheet, and building the pie chart from that.
When these reports were done on an ad-hoc, by-request basis, I could afford the time to monkey with the single incidents, but now I have to make the reports monthly, and there are nearly 70 locations involved. Is there a way to make injury types of "1" sum up into a "Miscellaneous" field automatically within the pivot table? (I'm using Excel 2010.)
Bookmarks