Overlapping column chart

This chart displays overlapping columns for base and target elements. The categories form the horizontal axis. You can select an element from the categories by clicking on the corresponding column.

Required steps: Data Source > Categories > Series > Filters

Optional steps: Browse data > Properties

Additional actions in Steps:

• Series step: Select a hierarchy from the list, then specify which element is driving your base values and which is driving the target values.

Additional actions in Edit:

• Show Percentage: Displays an extra column showing percentage changes for each category.
• Show Variance: Displays an extra column showing absolute variance for each category.
• Swap Base and Target: To quickly swap your base and target values for the chart.