All variance charts require a Compare by hierarchy.
The chart will then display the difference between the Base and Comparison Value members. For example, the current year could be set as the base value and the previous year as the comparison value. These members can be set directly from the dropdown, or driven from an Excel cell.
