# 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](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FwAv0re6DWJJjTtrxBENP%2FMixed%20Chart_Properties.gif?alt=media\&token=a9f45263-0657-4805-aeec-0881dd146633)

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](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FDzcas6n7NtOTpUkeGQW2%2Fimage.png?alt=media\&token=8d821107-5628-4852-8355-53c066e92bac)

### **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](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FCMgfe9SFXQuvkl3R9icU%2Fimage.png?alt=media\&token=24723fa3-7327-4662-96c6-70311890429b)

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

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FYzK4gT61dhugKXxQfUsj%2Fimage.png?alt=media\&token=ed15af8a-302c-40af-b091-255891b684c4)

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

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FRZSkw86bJGVDLabS4lWa%2Fimage.png?alt=media\&token=7b56e7b3-a22e-4c72-91d2-26442c903466)

{% 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>*](https://docs.bdb.ai/bdb-documentation/data-visualization/self-service/design/series-properties) 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;     ![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FDDWslVtcUM9tUv3mPMzO%2Fimage.png?alt=media\&token=a5b453cb-50bc-4586-97af-59925ea51b28)

  * **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;     ![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2F2gyNDLc1fpV6zH3KnnXX%2Fimage.png?alt=media\&token=2881e9d0-af46-404e-9bf4-6dd7d4610bcf)

* 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](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FhHedPakU5iS5PmEc8iW0%2Fimage.png?alt=media\&token=32563e90-9d33-4699-b761-de3e749dbc39)

&#x20;
