Combination chart

This chart displays column chart for the base element and a line chart for the target. 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 a color-coded pin chart above you current chart, which shows the relative variance for each category.
  • Show Variance: Displays a color-coded column chart above showing absolute variance for each category above your chart.
  • Swap Base and Target: To quickly swap your base and target values for the chart.