Offset comparison is a business chart type that shows two scenarios as bars/columns that overlap. The main scenario is in front, and the comparison scenario is in the back.

Setup

The offset comparison chart requires a Compare by hierarchy in the task pane. The member set as the base value appears as the bar/column in front, and the comparison value will appear behind. These members can be set directly from the dropdown, or driven from an Excel cell.

Formatting

Formatting task pane

Several formatting options can be set from the formatting pane. Here you can set the series formatting for both the base and comparison values, as well as:

  • Offset: How much the base and comparison values overlap.
The formatting pane.

Match To

When showing many charts on one page, it's important that the scales on all of them match. This will keep the charts looking the same. This can be done with the Match to setting in the chart properties.