# Column Stack chart

{% hint style="success" %}
*Check out the given walk-through on how to set the Column Stack chart properties.*
{% endhint %}

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fq1Y2nC9XDrWcLwg1gpYr%2Fuploads%2F6tbqCe4PAU0upkwIFFAp%2FApplying%20chart%20properties%20to%20Column%20chart.mp4?alt=media&token=955492f3-75fd-4a7c-a9ff-4a4162e6094b>" %}
***Applying Column Stack chat Properties***
{% endembed %}

Column charts are used when users want to compare the values of individual data points with another. They help in bringing out the highs and lows of the data set.

* **Best Situation to use Column charts:** Column charts are suitable for displaying data sets with negative values
* **Example:** To find the best and worst performers in an organization
* **Variations of this chart**
  * **Use stacked Column charts:** Where multiple categories can be clubbed together on top of each other, which makes addressing numerous questions easier.
  * **Use column side by side:** Where comparison between multiple categories becomes easier instead of toggling between charts.
  * **Add colour for quick insight:** Displaying the columns with colors helps users to pay immediate attention to the essential tasks.

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2Fjr2yEcz00IMS7YAZ6J4u%2Fimage.png?alt=media&#x26;token=4fe86c38-a337-4126-82b8-179f39b1a377" alt=""><figcaption><p>Default View displaying Data in Column chart</p></figcaption></figure>

## **Properties** <a href="#properties" id="properties"></a>

### **General Settings**

* **Style**: Select a style to display the data (the provided choices for this field are: Cluster, Stack, Stack Percentage, Stack Overlaid)
* **Order**: Select a sequence for displaying information

  * None
  * Ascending
  * Descending
  * Manual Sort (Users need to sort the dimensions by using the indicator signs manually)
    * By selecting an order (ascending or descending), the user needs to configure the following fields:
      * **Order By**- Select a value option from the drop-down menu to order the sequence of the data.
      * **Limit**- Set a number to display the requested data by this limit.
  * **Exclude Global Filter**: The view gets excluded from the Global Filter condition by putting a checkmark in the box.
  * **Show Data Label**: Data label gets displayed by using a checkmark in the given box.
  * **Enable Base Zero**: Base value gets presented from Zero by putting a checkmark in the given box.
  * **Show Legend**: Displays legend by turning on the radio button. After enabling ‘Show Legend,’ users need to select the following information:
  * **Legend Style**: Select one of the following options by using the drop-down menu.
    * Fixed
    * Floating
  * The following fields appear when the selected ***Legend Style*** option is ***Fixed***.
    * **Legend Font Size:** This option allows to increase or decrease the font size of the legend.
    * **Legend Orientation**: This option appears when ‘Show Legend’ is enabled, and the selected ‘Legend Style’ is Fixed. Users need to select an option out of the given choices using the drop-down menu.
      * Vertical
      * Horizontal
    * **Legend Checkbox**: Enable this option by a checkmark to add the checkbox beside the Legend.

  ![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FhoUETpLV687cUUHeIZ2f%2Fimage.png?alt=media\&token=449fb654-e13e-4cfe-bcd1-1691501d6435)​

  * **Slider**: Provide a checkmark in the box to enable the Slider.
    * **Fixed Slider Range**: Enable this option to fix slider range.

<figure><img src="https://2802995573-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fq1Y2nC9XDrWcLwg1gpYr%2Fuploads%2Fa3CvoBvinSmMOHrgheRB%2Fimage.png?alt=media&#x26;token=1fc13345-27a4-484f-ac57-e99e346edccf" alt=""><figcaption><p><em><strong>Applying the General Settings Properties</strong></em></p></figcaption></figure>

### **View Filter**

* **Filter**: Select a filter condition using the drop-down menu (E.g., ‘***team***’ option is the selected as a filter condition in the following image).

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark> The selected **View Filter** option will be reflected to customise the View data after adding the View to report.*
{% endhint %}

### **Category Axis**

* **Title**: Provide a title for the axis. (E.g., ‘Designation’ is the title for the category axis displayed in the following view).
* **Axis Label**: Enable the category axis label by putting a checkmark in the box.
* **Label Angle**: Select a display angle for the axis label. (the provided choices for this field are: 0, 45, 90 angles).

### **Primary Value Axis**

* **Title**: Provide a title for the Primary Value Axis.
* **Axis Label**: Enable the Primary Value Axis label by turning on the radio button.
* **Format Type**: Select a desired format type from the drop-down menu (the provided options for this field are: None, Auto, Percent, Thousand, Lacs, Crore, Million, Billion, Trillion, Quadrillion).
* **Currency Type**: Select a currency symbol to be displayed in the view (the provided options for this field are: None,  Rupees, Euro, Pound, USD, Yen, Cent).
* **Precision**: Set the after-decimal value (It displays up to 5 precision).

<figure><img src="https://2802995573-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fq1Y2nC9XDrWcLwg1gpYr%2Fuploads%2FbENrPW1S2HtvI6B0kBcp%2Fimage.png?alt=media&#x26;token=cc416c5f-a494-4f43-b004-fe3a7eba835e" alt=""><figcaption><p><em><strong>Applying View Filter, Category Axis, and Primary Value Axis</strong></em></p></figcaption></figure>

### **Secondary Value Axis**

Properties for the Secondary Value Axis gets displayed when two measures are dragged on the canvas.

* **Enable**: Put a checkmark in the box to enable the Secondary Value Axis.
* **Title**: Provide a title for the Secondary Value Axis.
* **Format Type**: Select a desired format type from the drop-down menu (the provided options for this field are: None, Auto, Percent, Thousand, Lacs, Crore, Million, Billion, Trillion, Quadrillion).
* **Currency Type**: Select a currency symbol to be displayed in the view (the provided options for this field are: None,  Rupees, Euro, Pound, USD, Yen, Cent).

{% hint style="info" %}
*Please Note:*

1. *When the selected Format Type is **Percentage**, you don’t get the **Currency Type** field.*
2. *The users must configure the* [***Series Properties*** ](https://docs.bdb.ai/self-service-visualization-3/design-canvas/series-properties)*of the dragged measure after enabling the **Secondary Value Axis** to display the same in the chart.*
   {% endhint %}

### **Insights**

* **Text:** *Provide any information regarding the chart. If any digit or character is required to be highlighted, put it inside two asterisks. (E.g., \*70%\* or \*skills\*).*
* **Text align:** There are three alignments to align the text.
  * Left
  * Right
  * Centre
* **Position:** There are two options to position the text.
  * Bottom
  * Right

<figure><img src="https://2802995573-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fq1Y2nC9XDrWcLwg1gpYr%2Fuploads%2FCUbvY8vgWYwe1LKzXzvQ%2Fimage.png?alt=media&#x26;token=d82bb8c2-1f4d-45ba-94d9-06764841c492" alt=""><figcaption><p><em><strong>Applying Secondary Value Axis and Insights Properties</strong></em></p></figcaption></figure>