Currently, the chart capabilities of ArcGIS are very basic, and it does not allow to group data by categories. I think it would be a great asset to be able to create not only pivot tables, but also pivot charts directly in ArcGIS Desktop without having to export the data to MS Excel. The symbology should match the one used in the layout.
