# Line Charts

{% tabs %}
{% tab title="Basic line" %}

## <mark style="color:blue;">1. Line chart</mark>

### Chart setup

1\. **Axis**

&#x20;     \- Drag a dimension to plot on the axis (e.g., Month).

2. **Values parameter**

&#x20;       \- Drag measures to analyze (e.g., 2024 Plan, 2024 Actuals, 2023 Actuals, 2022 Actuals).

3. **Chart type**

&#x20;       \- Select **Line** from the Line section of the Chart Type dropdown menu.

Line charts provide a clear and intuitive way to observe patterns and fluctuations in continuous data by connecting data points with straight lines.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FIrmBmYQyTXwckw1iXJ9N%2Fimage.png?alt=media&#x26;token=5b9bc159-e6b3-4897-9f16-4544dadec403" alt=""><figcaption></figcaption></figure>

Line charts can be converted into Spline and Stepped charts from the chart selection menu, without changing the configuration.

<div><figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FjREvYmR4uwfyGQHEh0JF%2Fimage.png?alt=media&#x26;token=0da9af6c-537b-41e3-b32a-dfa05fc43eea" alt=""><figcaption></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FZ8GGG4bGeyotfBYCzMnf%2F2025-05-23_13h38_59.png?alt=media&#x26;token=1e240bea-4fe7-4fc4-aecf-96728a1a64b1" alt=""><figcaption></figcaption></figure></div>

### 1. Customization & formatting options under Canvas settings

#### 1.1. Category format

Customize the line and marker style, color, and size from the Category format settings.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FUWzZubfs7iHXUGcUgUey%2Fimage.png?alt=media&#x26;token=292cca59-1a00-473b-a374-dffdc7fdacaf" alt=""><figcaption></figcaption></figure>
{% endtab %}

{% tab title="Stacked line" %}

## <mark style="color:blue;">2. Stacked line chart</mark>

### Chart setup

1\. **Axis**

&#x20;     \- Drag a dimension to plot on the axis (e.g., Month).

2. **Values parameter**

&#x20;       \- Drag measures to analyze (e.g., 2024 Plan, 2024 Actuals, 2023 Plan, 2023 Actuals, 2022 Plan, 2022 Actuals).

3. **Chart type**

&#x20;       \- Select **Stacked Line** from the Line section of the Chart Type dropdown menu.

> By stacking data series, these charts highlight the composition and progression of different categories, making them ideal for scenarios like tracking departmental contributions to total revenue or monitoring resource allocation across projects.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FpNlsZf5qW6BdKVwH7swm%2Fimage.png?alt=media&#x26;token=53068646-3715-4e42-9685-dcd503fa5ebf" alt=""><figcaption></figcaption></figure>

The stacked line can be converted into spline and stepped line variants by switching the chart type.
{% endtab %}

{% tab title="100% stacked line " %}

## <mark style="color:blue;">3. 100% Stacked line chart</mark>

### Chart setup

1\. **Axis**

&#x20;     \- Drag a dimension to plot on the axis (e.g., Month).

2. **Values parameter**

&#x20;       \- Drag measures to analyze (e.g., 2024 Plan, 2024 Actuals, 2023 Plan, 2023 Actuals, 2022 Plan, 2022 Actuals).

3. **Chart type**

&#x20;       \- Select **100% Stacked Stepped Line** from the Line section of the Chart Type dropdown menu.

> By representing data in percentages, the 100% stacked line charts allow for easier comparison between categories.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FlGkx1LLtUuAF6eFJA7y5%2Fimage.png?alt=media&#x26;token=48afdc15-8fc1-419b-b2fc-efa6430f03bf" alt=""><figcaption></figcaption></figure>

We've used a 100% Stacked Stepped Line chart for demonstration, but it can be converted into spline and line variants by switching the chart type.
{% endtab %}

{% tab title="Clustered line" %}

## <mark style="color:blue;">4. Clustered/ grouped line</mark>

### Chart setup

1\. **Axis**

&#x20;     \- Drag a dimension to plot on the axis (e.g., Month).

2. **Values parameter**

&#x20;       \- Drag measures to analyze (e.g., 2024 Plan, 2024 Actuals, 2023 Plan, 2023 Actuals, 2022 Plan, 2022 Actuals).

3. **Chart type**

&#x20;       \- Select **Grouped/clustered Line** from the Line section of the Chart Type dropdown menu.&#x20;

> Grouped line charts display several series side-by-side on the same axis. They highlight similarities, differences, and trend patterns across categories.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F4xiGnMpcvOi99Sk1PTup%2Fimage.png?alt=media&#x26;token=1c2858d7-9cdc-46cc-aec0-2edc4f5a6b23" alt=""><figcaption></figcaption></figure>
{% endtab %}
{% endtabs %}

{% tabs %}
{% tab title="Baseline" %}

## <mark style="color:blue;">1. Baseline</mark>

### Chart setup

1\. **Axis**

&#x20;     \- Drag a dimension to plot on the axis (e.g., Month).

2. **Values parameter**

&#x20;       \- Drag measures to analyze (e.g., 2024 Actuals).

3. **Chart type**

&#x20;       \- Select **Baseline** from the Line section of the Chart Type dropdown menu.&#x20;

> A **baseline chart** incorporates a reference line - known as the baseline. This baseline can be a fixed value, such as zero, a target threshold, or a dynamically calculated value based on historical data. Baseline charts are particularly useful in highlighting deviations, trends, and anomalies relative to this reference point.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FxstuZfueTOnYzewuLK3G%2Fimage.png?alt=media&#x26;token=e81928c9-66cc-4bfa-887b-c0f13ed9de25" alt=""><figcaption><p>Data management for baseline charts</p></figcaption></figure>
{% endtab %}

{% tab title="Variance line" %}

## <mark style="color:blue;">2. Variance line</mark>

### Chart setup

1\. **Axis**

&#x20;     \- Drag a dimension to plot on the axis (e.g., Month).

2. **Values parameter**

&#x20;       \- Drag measures to analyze (e.g., 2024 Actuals, , 2023 Actuals).

3. **Chart type**

&#x20;       \- Select **Variance line** from the Line section of the Chart Type dropdown menu.&#x20;

> A **variance line chart** illustrates the differences between two comparable metrics over time, such as actual versus budgeted figures. By plotting measures as lines on the same graph, the chart highlights deviations, enabling quick identification of periods where performance diverged from expectations.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FKocemdBzGkw6NPIJryZr%2Fimage.png?alt=media&#x26;token=8b9036cb-0468-4ff9-afdc-8e96e1984790" alt=""><figcaption><p>Data management for variance line charts</p></figcaption></figure>
{% endtab %}
{% endtabs %}

## Additional formatting options

Here are the other settings that help you refine your line chart.

<table><thead><tr><th width="143.5">Feature</th><th>Description</th><th data-type="content-ref">Link</th></tr></thead><tbody><tr><td>Number</td><td>Configure number formatting (decimals, units)</td><td><a href="../working-with-analytics+/3.-charts/3.8.-display-settings-for-charts/charts-number-settings">charts-number-settings</a></td></tr><tr><td>Legend</td><td>Show/hide and customize the legends</td><td><a href="../working-with-analytics+/3.-charts/3.8.-display-settings-for-charts/charts-legend-settings">charts-legend-settings</a></td></tr><tr><td>Data Label</td><td>Show exact values for each data point</td><td><a href="../working-with-analytics+/3.-charts/3.6.-data-label-customizations">3.6.-data-label-customizations</a></td></tr><tr><td>Trellis</td><td>Create small multiples using category split</td><td><a href="../working-with-analytics+/6.-trellis-customizations">6.-trellis-customizations</a></td></tr><tr><td>Conditional Formatting</td><td>Apply color rules to highlight values</td><td><a href="../working-with-analytics+/9.-conditional-formatting">9.-conditional-formatting</a></td></tr><tr><td>Sorting</td><td>Sort axis order</td><td><a href="../working-with-analytics+/10.-sort-and-reorder-data/sorting-data">sorting-data</a></td></tr><tr><td>Ranking</td><td>Limit to top/bottom N categories</td><td><a href="../working-with-analytics+/11.-ranking-data-topn/ranking-for-charts">ranking-for-charts</a></td></tr></tbody></table>