This is an Eval Central archive copy, find the original at depictdatastudio.com.
By default, Excel will sort categories alphabetically or chronologically.
But we can use the “brackety compass rose” to customize our pivot tables… which lets us customize our graphs.
For example, with this technique, we can re-sort Agree, Disagree, Neutral, Strongly Agree, Strongly Disagree…. into Strongly Agree, Agree, Neutral, Disagree, Strongly Disagree.
Learn how in this lesson:
What’s Inside
- 0:00 Intro
- 1:18 Re-Sorting Months in Pivot Tables
- 6:26 Re-Sorting Survey Response Options in Pivot Tables