# 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FPqtEpvsHRf6oxyDgja2w%2Fimage.png?alt=media&#x26;token=00952153-a22a-4352-85e1-e5d4d6b2a6ac" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FZa9o6T4CvLe4kfmUpDI5%2Fimage.png?alt=media&#x26;token=1a6ba985-6044-4de2-b35f-f258aaecfa6d" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FyAGiTcBywYXwE0FXFldP%2Fimage.png?alt=media&#x26;token=dc60cefd-b6a0-43c3-88b1-9c60a872956b" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FSSRoDHTDNy1WQN7xi3be%2Fimage.png?alt=media&#x26;token=1a59d392-4bd3-4d84-a05d-d2e1fc904855" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FHknWhfc2gDqtMA5p2YCZ%2Fimage.png?alt=media&#x26;token=5130158e-3af0-432a-9597-b2238d5d51dd" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F7YJ47seY8Tk592XBKIl0%2Fimage.png?alt=media&#x26;token=9b5f3d89-087d-4c5c-8f8b-a107c719b8e6" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F44TLmLRVJrfpT4k0jGsg%2Fimage.png?alt=media&#x26;token=bd034e26-2c6c-4938-8dce-c85b235452eb" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FzPfBqAjNCz0N1ovbVgTp%2Fimage.png?alt=media&#x26;token=39ffa51b-689e-40f3-ae0b-bb655c931fe9" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FRme7h8G168kSQou4omMD%2Fimage.png?alt=media&#x26;token=41c5f299-fc75-43aa-ac14-f8bc44c1eb2d" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FyhS9aod3uWsxQDKXMNoj%2Fimage.png?alt=media&#x26;token=c279e4a8-c437-4b86-8575-5e5e157d7b19" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Fal9G2s7qNqyNYPGoN0wW%2Fimage.png?alt=media&#x26;token=06498e35-1a70-42ce-84c3-9269b386d087" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F5aej2vADp7wFHbaqbnjh%2Fimage.png?alt=media&#x26;token=e2c62366-c06d-43d0-bdc3-3e6fe2671921" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FO8vAwbIKlbZCqHaNmnpp%2Fimage.png?alt=media&#x26;token=19aa9ede-358b-4e4e-94cf-ccc73aa69531" 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.](https://docs.inforiver.com/analytics+/working-with-analytics+/2.-data-management)

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Fr4EgdJmrQEFvrXxsQWy5%2Fimage.png?alt=media&#x26;token=8a40797e-7d72-43a5-b0d2-86a222c87f94" 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.](https://docs.inforiver.com/analytics+/working-with-analytics+/7.-customize-measures)

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FdjsjnnHMRdkK6KjaycwN%2Fimage.png?alt=media&#x26;token=87e98a3e-545d-4ea0-a7fd-611beda30b2f" 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="../working-with-analytics+/3.-charts/3.8.-display-settings-for-charts/charts-number-settings">charts-number-settings</a></td></tr><tr><td>Legend</td><td>Show/hide and customize the legends</td><td><a href="../working-with-analytics+/3.-charts/3.8.-display-settings-for-charts/charts-legend-settings">charts-legend-settings</a></td></tr><tr><td>Data Label</td><td>Show exact values for each data point</td><td><a href="../working-with-analytics+/3.-charts/3.6.-data-label-customizations">3.6.-data-label-customizations</a></td></tr><tr><td>Trellis</td><td>Create small multiples using category split</td><td><a href="../working-with-analytics+/6.-trellis-customizations">6.-trellis-customizations</a></td></tr><tr><td>Conditional Formatting</td><td>Apply color rules to highlight values</td><td><a href="../working-with-analytics+/9.-conditional-formatting">9.-conditional-formatting</a></td></tr><tr><td>Sorting</td><td>Sort axis order</td><td><a href="../working-with-analytics+/10.-sort-and-reorder-data/sorting-data">sorting-data</a></td></tr><tr><td>Ranking</td><td>Limit to top/bottom N categories</td><td><a href="../working-with-analytics+/11.-ranking-data-topn/ranking-for-charts">ranking-for-charts</a></td></tr></tbody></table>