# Mixed chart

{% hint style="success" %}
Check out the below-given walk-through on how to use Mixed chart in the Self-service visualisation.
{% endhint %}

![Mixed chart Properties](/files/wj54NMOatbG6QqXIfsNk)

The Mixed Chart is a combination of a line chart and a column chart. It can plot 3-series of data on the graph. It is primarily used to emphasize a different series of information.

* [x] **The best situation to use Mixed Chart:** To compare multiple categories
* [x] **Example:** To analyse a company's budget v/s revenue.
* [x] **Variations of this chart-The following are the variations for this chart:**
  * [ ] **Use stacked Column charts:** Multiple categories can be clubbed together on top of each other, which makes addressing multiple questions easier.
  * [ ] **Use columns side by side:** Comparison between multiple categories becomes easier instead of toggling between charts and data.
  * [ ] **Add colour for quick insight:** Where displaying columns with colours allows users to pay immediate attention to the essential tasks.

![View with Mixed chart](/files/4R70uTGysqXrR862FLnq)

### **Properties**

You can access the chart specific properties from the ***Design*** page. It gets listed under the  ***Properties*** tab on the right-side panel.

![The chart-specific Properties tab](/files/ZSndnog8hBedbmVb4RMX)

**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: The user needs 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 bo&#x78;**.**
  * **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 providing a checkmark in the box.
  * **Show Point**: Enable the Show Point option by using a checkmark in the given box.
  * **Line Form**: Select a line format from the drop-down menu (the provided choices for this field are: Curve and Segment).
  * **Show Legend**: Provide a checkmark in the box to display Legend. 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&#x20;
      * 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., ‘**Source**’ is the selected filter condition in the following image).

#### **Category Axis**

* **Title**: Provide a title for the axis&#x20;
* **Axis Label**: Enable the Category Axis label by putting a checkmark in the box.
* **Label Angle**: Select a display angle for the axis label.

![](/files/3eT1UY9UTcchinnBkEqJ)

#### **Primary Value Axis**

* **Title**: Provide a title for the Primary Value Axi&#x73;**.**
* **Axis Label**: Enable the Primary Value Axis label by putting a checkmark in the box.
* **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)

#### **Secondary Value Axis**

Properties for the **Secondary Value Axis** get 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
* **Precision**: Set the after-decimal value (It displays up to 5 precision)         &#x20;

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

![](/files/BSUM7PYIphty7o5EFnDs)

{% hint style="info" %} <mark style="color:green;">Please Note:</mark> When the selected ***Format Type*** is ***Percentage***, you don't get the ***Currency Type*** field.&#x20;
{% endhint %}

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.

* Access Secondary Value Axis using the ***Properties*** tab and enable it.
* Click the ***Series Properties*** provided next to the measure name&#x20;
* A new window opens.
* Configure the required details:

  * **Aggregation**-select an aggregation using the drop-down menu (By default, it displays the second aggregation type that is ***Sum***)
  * **Display Name**- provide a name to be displayed in the legend.
  * **Series Type**- select a series type to display the secondary value.
  * **Point Shape:** Select a point shape using the drop-down menu.
  * **Line Type:** Select a line type using the drop-down menu.

  &#x20;     ![](/files/uihx0wNi0rERgfqjEUrY)

  * **Axis**-select an axis to display the values of the second measure.
  * **Colour**- Select a colour for the series.
  * **Data Label Colour**-select a colour for the Data Label.
  * **Data Label Position**: Select an option using the drop-down icon.
* Click the ***APPLY*** option.

&#x20;     ![](/files/UwgVICxVabbjonvRnTgf)

* Navigate to the ***Properties*** tab.&#x20;
* The selected changes can be seen in the ***Secondary Value Axis*** of the view.     &#x20;

![The View after applying Series Properties changes](/files/Jm9xFHakOWowthcdSotS)

&#x20;


---

# 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.bdb.ai/bdb-documentation/data-visualization/self-service/chart-gallery/mixed-chart.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.
