View Single Post
  #1   Report Post  
puck1263 puck1263 is offline
Junior Member
 
Posts: 20
Default Sorting a stacked column

Hi-
I have 3 columns in a pivot table that form a stacked column chart. I currently sort them manually by adding a sum column and manually moving the rows (highest total going left to right).

Other column charts will give me a total column that I can easily sort by to do the same thing, but doesn't seem to be an option for stacked (I checked the box to total rows in pivot table options, but it doesn't giev anything).

Am I missing something?