# Line chart

The line chart connects individual numeric data points to create a sequence of values. They are primarily used to display trends over a period.

* **Best Situation to use Line Charts:** View trends in data over a period
* **Examples:** To indicate increasing revenue or varying stock price
* **Variations of this chart**
  * **Mixed Chart**- Combine a line graph with column charts to provide visual cues for further investigation
    * **Example:** A column chart representing the numeric score of students combined with the line chart corresponding proficiency score.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/ib8bKThncQFbORyElp5a/image.png" alt=""><figcaption><p><em><strong>Default View using the Line chart</strong></em></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 (default option)
  * Ascending
  * Descending
  * Manual Sort (Users need to sort the dimensions by using the indicator signs manually)
    * (If the user selects the ***Manual Sort*** as the ordering option, they get an icon clicking which the Manual Sort window appears)
  * 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 using a checkmark in the given 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**: 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.
* **Slider**: Slider gets displayed by putting a checkmark in the box.
  * **Fixed Slider Range**: Enable the checkbox to get the fixed Slider range.&#x20;

<figure><img src="https://2350624874-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvIDgRfkRB1bQpGtEDFfQ%2Fuploads%2FCV9QQ84wtABjArot0rKR%2Fimage.png?alt=media&#x26;token=345426e7-c244-483e-8b71-f28c0f499951" alt=""><figcaption><p><em><strong>General Properties for the Line chart</strong></em></p></figcaption></figure>

<figure><img src="https://2350624874-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvIDgRfkRB1bQpGtEDFfQ%2Fuploads%2FQ4HbaYvAH1gOPC3aG6r9%2Fimage.png?alt=media&#x26;token=a10e7b1d-94da-4ce3-8bbb-6310149ec16f" alt=""><figcaption><p><em><strong>Modified Line chart after applying the General Properties as mentioned in the above-given image</strong></em></p></figcaption></figure>

### **View Filter**

* **Filter**: Select a filter condition using the drop-down menu.

{% 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.
* **Axis Label**: Enable the category axis label by using a checkmark in the box.
* **Label Angle**: Select a display angle for the axis label.

### **Primary Value Axis**

* **Title**: Provide a title for the Primary Value Axis.
* **Axis Label**: Enable the Primary Value Axis label by using 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, 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://2350624874-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvIDgRfkRB1bQpGtEDFfQ%2Fuploads%2F3fZdkrgUb2Hb8YKnm4fn%2Fimage.png?alt=media&#x26;token=8529f115-a2bc-4316-80b1-baa018362c93" alt=""><figcaption><p><em><strong>Configuring View Filter, Category Axis, and Primary Value Axis</strong></em></p></figcaption></figure>

<figure><img src="https://2350624874-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvIDgRfkRB1bQpGtEDFfQ%2Fuploads%2FUaFBrA7Bgn88wa2P2QNP%2Fimage.png?alt=media&#x26;token=7c6ea2be-a09b-4521-b3ad-4b665541c95b" alt=""><figcaption><p>Modified <em><strong>View after applying the above-given View Filter, Category Axis, and Primary Value Axis Properties</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).
* **Precision**: Set the after-decimal value (It displays up to 5 precision).

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

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\*).
* **Font Size:** Set/modify Font Size of the Insights text.
* **Font Color:** Select a Font color for the Insights Text.
* **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://2350624874-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvIDgRfkRB1bQpGtEDFfQ%2Fuploads%2FMlggtuLZOmpQAOcx8pnH%2Fimage.png?alt=media&#x26;token=2600ebf3-89a5-4fb5-b815-ae055036a774" alt=""><figcaption><p><em><strong>The modified View after applying the Secondary Value Axis and Insights Properties</strong></em></p></figcaption></figure>
