Displaying the Difference Between Two Data Points
You can select two data points in a chart to quickly see the difference between their values. For example, you can compare a year-over-year percentage increase or decrease, or see the delta between two versions.
Context
This feature applies to Bar/Column or Combination Column & Line charts.
An arrow shows which column is the second column chosen, and the value is displayed both numerically and as a percentage. For vertical charts, the delta graphic and the value are displayed to the right of the selected columns. For horizontal charts, the delta graphic is displayed below the selected bars, and the value is displayed on the second selected bar.
|
Height of second column or bar |
Positive or negative delta |
|---|---|
|
Taller |
Positive |
|
Shorter |
Negative |
Procedure
- In your chart, select one bar or column.
- Move the cursor to another bar or column and select it.
Results
A line is drawn between the two columns and the difference is displayed.