# Column/Bar Charts

### 1. Basic column charts

{% tabs %}
{% tab title="Overlapped column" %}

## &#x20;                       <mark style="color:$success;">**Overlapped column**</mark>

### Chart setup to build an overlapped column:

| Configuration option | Configuration value                                                                        |
| -------------------- | ------------------------------------------------------------------------------------------ |
| **Axis**             | Drag a dimension to plot on the axis (e.g., Quarter).                                      |
| **Values parameter** | Drag measures to analyze (e.g., 2022 Actuals, 2022 Plan, 2021 Actuals).                    |
| **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.

<figure><img src="/files/uPYuMqjvpznevnb7qazD" alt=""><figcaption><p>Overlapped column</p></figcaption></figure>
{% endtab %}

{% tab title="Stacked column" %}

## **Stacked column**

### Chart setup

\
1\. **Axis**

&#x20;   \- Drag a dimension to plot on the axis (e.g., Month ).

2. **Values parameter**

&#x20;   \- Drag measures to analyze (e.g., 2022 Actuals,  2021 Actuals).

3. **Small multiples** parameter&#x20;

&#x20;     \- Drag the dimension that will be used to plot stacks (e.g., Sub Category)

4. **Chart type**

&#x20;    \- Select **Stacked column** from the Bar/Column section of the  Chart Type dropdown menu.

> Compares the actuals with the previous year's actuals. The stacks show the contribution of product categories to the overall actuals.

<figure><img src="/files/FAPD4uOKh2bnLnj8rxU2" alt=""><figcaption><p>Stacked column</p></figcaption></figure>

## Stacked measure chart

### Chart setup

\
1\. **Axis**

&#x20;   \- Drag a dimension to plot on the axis (e.g., Month ).

2. **Values parameter**

&#x20;   \- Drag measures to analyze (e.g., 2024 Actuals,  2024 Plan, 2023 Actuals,  2023 Plan, 2022 Actuals,  2022 Plan).

3. **Chart type**

&#x20;    \- Select **Stacked column** from the Bar/Column section of the  Chart Type dropdown menu.

> The stacks break down the contribution of each measure to the total for each month.

<figure><img src="/files/kJyDjhdF3QAC3jyNUPE0" alt=""><figcaption><p>Stacked measure chart</p></figcaption></figure>
{% endtab %}

{% tab title="Cluster column" %}

## **Cluster column**

### Chart setup

\
1\. **Axis**

&#x20;   \- Drag a dimension to plot on the axis (e.g., Month ).

2. **Values parameter**

&#x20;   \- Drag measures to analyze (e.g., 2022 Plan, 2022 Actuals,  2021 Plan, 2021 Actuals, 2020 Actuals).

3. **Chart type**

&#x20;    \- Select **Cluster column** from the Bar/Column section of the  Chart Type dropdown menu.

> This chart plots multiple measures side-by-side for quick comparisons.

<figure><img src="/files/37tt0qDMIxQKuErNGNXX" alt=""><figcaption><p>Cluster column</p></figcaption></figure>
{% endtab %}

{% tab title="Win loss chart" %}

## **Win loss chart**

### Chart setup

\
1\. **Axis**

&#x20;   \- Drag a dimension to plot on the axis (e.g., Level 2 Description).

2. **Values parameter**

&#x20;   \- Drag measures to analyze (e.g., Actuals).

3. **Chart type**

&#x20;    \- Select  **Win and loss column** from the Bar/Column section of the  Chart Type dropdown menu.

> The win and loss chart depicts categories that are performing well against categories that are under-performing.

<figure><img src="/files/6e6EWxgWLRkNrvpUKlip" alt=""><figcaption><p>Win loss column</p></figcaption></figure>
{% endtab %}
{% endtabs %}

### 2. Special charts

{% tabs %}
{% tab title="Split bar" %}

## **Split bar**

### Chart setup

\
1\. **Axis**

&#x20;   \- Drag a dimension to plot on the axis (e.g., Month).

2. **Values parameter**

&#x20;   \- Drag measures to analyze (e.g., 2022 Actuals, 2021 Actuals).

3. **Chart type**

&#x20;    \- 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.

<figure><img src="/files/trl4jNvEAJr1jrBtFd6V" alt=""><figcaption><p>Side by sided bar</p></figcaption></figure>
{% endtab %}
{% endtabs %}

### 3. IBCS chart

{% tabs %}
{% tab title="Integrated variance column" %}

## Integrated variance column

### Chart setup

1\. **Axis**

&#x20;   \- Drag a dimension to plot on the axis (e.g., Month).

2. **Values parameter**

&#x20;   \- Drag measures to analyze (e.g., 2022 Actuals, 2021 Actuals, 2022 Plan).

3. **Chart type**

&#x20;    \- Select **Integrated variance column** from the Bar/Column section of the Chart Type dropdown menu.

> &#x20;This chart plots the AC/PY/PL/FC measures and plots the relative variance for PY and PL as per IBCS.

<figure><img src="/files/90NDyAvprHmBrl73j2HM" alt=""><figcaption><p>IBCS Integrated variance column</p></figcaption></figure>
{% endtab %}
{% endtabs %}

### 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.

<figure><img src="/files/7NBibvFiCLiu4GJ63hyr" alt=""><figcaption><p>Defining a border</p></figcaption></figure>

#### 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.

<figure><img src="/files/0OvAF9nO28eu3n8EuPtU" alt=""><figcaption><p>Transparency and match toggle</p></figcaption></figure>

### 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.

<figure><img src="/files/0cb3KmiNwfEucc6DKcYA" alt=""><figcaption><p>Changing the measure associated to a bar</p></figcaption></figure>

#### 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.

<figure><img src="/files/ZU7KkY0mTFvG0UfJN12W" alt=""><figcaption><p>Change the fill pattern</p></figcaption></figure>

#### 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.

<figure><img src="/files/12qdsaZVBXXyIY1hGXIL" alt=""><figcaption><p>Changing the bar color</p></figcaption></figure>

#### 5.4. Enabling and disabling the data label

You can enable or disable the data labels for a particular measure.&#x20;

<figure><img src="/files/mU8ZbinjvymiDYxsUoFV" alt=""><figcaption><p>Disabling data labels</p></figcaption></figure>

#### 5.5. Navigate to measure management

You can open the pivot data window and configure measures and categories. [Learn more about data management.](/analytics+/working-with-analytics+/2.-data-management.md)

<figure><img src="/files/wxssiNs06NWebFBZJznt" alt=""><figcaption><p>Open pivot data</p></figcaption></figure>

#### 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.&#x20;
* Show or hide measures

[Learn more about measure series configurations.](/analytics+/working-with-analytics+/7.-customize-measures.md)

<figure><img src="/files/RFdEix2QxXeJSFoFfBpI" alt=""><figcaption><p>Measure series</p></figcaption></figure>

## Additional formatting options

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

<table><thead><tr><th width="143.5">Feature</th><th>Description</th><th data-type="content-ref">Link</th></tr></thead><tbody><tr><td>Number</td><td>Configure number formatting (decimals, units)</td><td><a href="/pages/5luh7CNmlb8gDCUt1Cdo">/pages/5luh7CNmlb8gDCUt1Cdo</a></td></tr><tr><td>Legend</td><td>Show/hide and customize the legends</td><td><a href="/pages/DKKnFEcoc3dq7SY8pPwT">/pages/DKKnFEcoc3dq7SY8pPwT</a></td></tr><tr><td>Data Label</td><td>Show exact values for each data point</td><td><a href="/pages/hlfbb3nncB1Juac8B2M1">/pages/hlfbb3nncB1Juac8B2M1</a></td></tr><tr><td>Trellis</td><td>Create small multiples using category split</td><td><a href="/pages/gZGiSWPH6pyEPgCUyJ7G">/pages/gZGiSWPH6pyEPgCUyJ7G</a></td></tr><tr><td>Conditional Formatting</td><td>Apply color rules to highlight values</td><td><a href="/pages/eAlYz7nnGGHBwj0vsrG2">/pages/eAlYz7nnGGHBwj0vsrG2</a></td></tr><tr><td>Sorting</td><td>Sort axis order</td><td><a href="/pages/DBrCRJn3JzquaVGXnE0Z">/pages/DBrCRJn3JzquaVGXnE0Z</a></td></tr><tr><td>Ranking</td><td>Limit to top/bottom N categories</td><td><a href="/pages/AmGsNJOt6hyWbMuwohm6">/pages/AmGsNJOt6hyWbMuwohm6</a></td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.inforiver.com/analytics+/quick-charts/column-bar-charts.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.