Database Reference
In-Depth Information
Figure 9-32. A Calculated Field that determines the absolute value, or magnitude, of the change
Now that these fields are created, let's do the following to complete the slopegraph itself:
1. Drag
Direction
to Color.
2. Drag
Magnitude
to Size.
3. Drag
Selected
to Label and change the label so that the Club name and the value are
in line, with a comma separating them.
4. Filter out the Clubs that were either promoted or relegated after the 2012/2013 season.
5. Clean up the fonts (change them all to Gill Sans MT).
Step 5, numbers 1-5 are shown in
Figure 9-33
.