What are the steps to create BUMP charts in Excel?

A Bump Chart is a special form of a line plot designed for exploring changes in rank over time. This chart helps compare the position / performance / ranking of multiple observations rather than the actual values itself.

  1. Step 1: Add dimension and measures.
  2. Step 2: Select a Quick Table Calculation.
  3. Step 3: Select a field to compute.
  4. Step 4: Duplicate measure.
  5. Step 5: Change mark type.
  6. Step 6: Select Dual Axis.
  7. Step 7: Final Bump chart.