# Column Stack chart

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

![](https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FhehVfOdvklYhLm9KJAcs%2FColumn%20Stack%20Chart_Properties.gif?alt=media\&token=f485a8f2-b909-4764-83c8-d87ad913be72)

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

* [ ] **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 colours helps users to pay immediate attention to the essential tasks.

![Default View displaying Data in Column chart](https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2Fjr2yEcz00IMS7YAZ6J4u%2Fimage.png?alt=media\&token=4fe86c38-a337-4126-82b8-179f39b1a377)

### **Properties**

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

  &#x20;             ![](https://4128708524-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)

  * **Enable Slider**: Provide a checkmark in the box to enable the Slider.

#### **View Filter**

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

#### **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).
* **Currency Type**: Select a currency symbol to be displayed in the view (the provided options for this field are: None, Euro, Rupees, Pound, USD, Yen, Cent).
* **Precision**: Set the after-decimal value (It displays up to 5 precision).

![The view gets modified as per the applied Properties](https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FSJdOSERIeCicaLBAwIJL%2Fimage.png?alt=media\&token=0ff4e715-95db-4da6-8ed8-66623a26b227)

#### **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.
* **Currency Type**: Select a desired currency symbol from the list.

{% hint style="info" %} <mark style="color:green;">Please Note:</mark>&#x20;

1. When the selected Format Type is ***Percentage***, you don’t get the ***Currency Type*** field. &#x20;
2. The users must configure the [*<mark style="color:blue;">**Series Properties**</mark>*](https://docs.bdb.ai/7.6/data-visualization/self-service/design-workspace/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&#x20;

![Further modified View ](https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FeDegSjF8J7cTBA0dMHqx%2Fimage.png?alt=media\&token=4b8f12e2-604c-4616-9bb4-a434e266df21)
