> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/bdb-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/bdb-documentation/data-visualization/self-service/chart-gallery/column-stack-chart.md).

# Column Stack chart

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

![](/files/8DpiTYHBLqinBFv4h46O)

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](/files/UuWBYr5OitVry4hUXTsv)

### **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
  * **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.
  * **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](/files/nyJcxngwgSW8myySLapI)

#### **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>*](/bdb-documentation/data-visualization/self-service/design/series-properties.md) 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 ](/files/P5MTlLVQyNeOOCaI0DZ8)
