ultros1234
New Member
Hi folks --
I'm trying to create a dashboard with dynamic charts and slicers in Excel 2010. I have a pivot table set up that shows the count of how many customer complaints we had in various categories, with a slicer that lets you select what year you want to look at. This makes a nice bar graph of our biggest complaint categories. In other words...
- column labels = year
- row labels = category
- values = count of complaint ID
Here's the problem: I want to sort the graph by count of complaint ID, largest to smallest. I can do this manually by right clicking on one of the count values in the table and sorting, but if I use the slicer to change which year I'm looking at, my sorting goes away. How can I automatically sort by count of ID even when I change what I'm filtering in other columns?
I'm trying to create a dashboard with dynamic charts and slicers in Excel 2010. I have a pivot table set up that shows the count of how many customer complaints we had in various categories, with a slicer that lets you select what year you want to look at. This makes a nice bar graph of our biggest complaint categories. In other words...
- column labels = year
- row labels = category
- values = count of complaint ID
Here's the problem: I want to sort the graph by count of complaint ID, largest to smallest. I can do this manually by right clicking on one of the count values in the table and sorting, but if I use the slicer to change which year I'm looking at, my sorting goes away. How can I automatically sort by count of ID even when I change what I'm filtering in other columns?