asked on
Can't sort a Stacked Pivot Chart
Hi
I have stacked Pivot Charts where the results are displayed as 100%. I want to sort the chart so that the maximum vacant percentage (87.5%) is at one end and the smallest vacant value (18.23) is at the opposite end.
When I right click and try and sort it form the smallest to the largest percentage it wont sort correctly. I suspect it is sorting on the sum of vacant values and not the calculated percentage.
Any idea how I can sort the pivot chart. sample file attached?
Excel-Stacked-Chart.xlsx
I have stacked Pivot Charts where the results are displayed as 100%. I want to sort the chart so that the maximum vacant percentage (87.5%) is at one end and the smallest vacant value (18.23) is at the opposite end.
When I right click and try and sort it form the smallest to the largest percentage it wont sort correctly. I suspect it is sorting on the sum of vacant values and not the calculated percentage.
Any idea how I can sort the pivot chart. sample file attached?
Excel-Stacked-Chart.xlsx
Microsoft ExcelMicrosoft Access
Last Comment
crystal (strive4peace) - Microsoft MVP, Access
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I have recommended this question be closed. A correct answer was given.
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit.