Column/Bar Charts

1. Basic column charts

Overlapped column

Overlapped column

Chart setup

1. Axis

- Drag a dimension to plot on the axis (e.g., Quarter).

1. Values parameter

- Drag measures to analyze (e.g., 2022 Actuals, 2022 Plan, 2021 Actuals).

1. Chart type

- Select Overlapped column from the Bar/Column section of the Chart Type dropdown menu.

The overlapped column chart compares the actuals with the previous year's actuals and plan.

Overlapped column

Stacked column

Cluster column

Win loss chart

2. Special charts

Split bar

Split bar

Chart setup

1. Axis

- Drag a dimension to plot on the axis (e.g., Month).

1. Values parameter

- Drag measures to analyze (e.g., 2022 Actuals, 2021 Actuals).

1. Chart type

- Select Split bar from the Bar/Column section of the Chart Type dropdown menu.

This chart shows two measures side-by-side in horizontal orientation enabling easy comparisons between 2 measures.

Side by sided bar

3. IBCS chart

Integrated variance column

Integrated variance column

Chart setup

1. Axis

- Drag a dimension to plot on the axis (e.g., Month).

1. Values parameter

- Drag measures to analyze (e.g., 2022 Actuals, 2021 Actuals, 2022 Plan).

1. Chart type

- Select Integrated variance column from the Bar/Column section of the Chart Type dropdown menu.

This chart plots the AC/PY/PL/FC measures and plots the relative variance for PY and PL as per IBCS.

IBCS Integrated variance column

4. Customization & formatting under Canvas settings

4.1. Border

Define borders for bar charts with the Border option under Canvas settings. Set a custom width and border color.

Defining a border

4.2. Transparency

Set the transparency for bar charts. When you increase the transparency factor, you can enable the Match color toggle. The border color will align with the bar color when the toggle is enabled.

Transparency and match toggle

5. On-object interactions for bar charts

Let's look at on-object customizations for the bar chart.

5.1. Changing the measure

When you have a multi-measure bar chart, you can click on a particular bar and choose the measure.

Changing the measure associated to a bar

5.2. Changing the fill pattern

You can choose between solid, outlined, and hatched measure fill patterns. This feature can be used to depict the previous year and forecast bars.

Change the fill pattern

5.3. Changing the bar color

You can choose a custom color for the bars. The bar color is reflected in the title as well.

Changing the bar color

5.4. Enabling and disabling the data label

You can enable or disable the data labels for a particular measure.

Disabling data labels

5.5. Navigate to measure management

You can open the pivot data window and configure measures and categories. Learn more about data management.

Open pivot data

5.6. Navigate to measure series

You can open the measure series configuration to:

• Change the chart type to an area/line/bar for a particular measure.

• Change the y-axis (Y-axis 1 or Y-axis 2) on which a measure is plotted.

• Show or hide measures

Learn more about measure series configurations.

Measure series

Additional formatting options

Here are the other settings that help you refine your bar/column chart.

Feature	Description	Link
Number	Configure number formatting (decimals, units)	Charts - number settings
Legend	Show/hide and customize the legends	Charts - legend settings
Data Label	Show exact values for each data point	3.6. Data label customizations
Trellis	Create small multiples using category split	6. Trellis customizations
Conditional Formatting	Apply color rules to highlight values	9. Conditional formatting
Sorting	Sort axis order	Sorting data
Ranking	Limit to top/bottom N categories	Ranking for charts