# Error bar

Error bars are graphical representations used in charts to indicate the variability or uncertainty of data. They visually depict the range within which the values are expected to lie.

{% hint style="info" %}
One error bar can be created per measure.
{% endhint %}

### 1. Apply to

Select the measure for which the error bar should be plotted.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FmSFcB0N369CMseSJwk6h%2Fimage.png?alt=media&#x26;token=68e050fe-f5d4-4d39-b0bf-67e64de016f5" alt=""><figcaption><p>Apply to option</p></figcaption></figure>

### 2. Stacked groups

For stacked and cluster charts, you can choose the category(ies) to render error bars for.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FDTqr29Q2CdSx2uIZXUA0%2Fimage.png?alt=media&#x26;token=0777ae21-6bae-4927-9d68-84e334ea2a77" alt=""><figcaption><p>Error bars for stacked/cluster charts</p></figcaption></figure>

### 3. Display

Error bars can be plotted based on a user-specified percentage or value or based on measures.

#### **2.1. By Percentage**

Set an upper and lower percentage limit based on the data point. In this example, let's consider the Pacific region. The error bar values of  217.0m and 130.2m represent a 25% upper and lower limit with respect to 173.6m - which is the data point value.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F0AzEsILWIIe1VrOE0Swn%2Fimage.png?alt=media&#x26;token=e2ffdd98-75de-4240-8934-85eaa3e2b7a1" alt=""><figcaption><p>Display - by percentage</p></figcaption></figure>

#### **2.2. By Value**

Assign the upper and lower bound values with respect to each data point. Let's look at the Pacific region again. The error bar values of  198.6m and 158.6 represent an upper limit of 25m and a lower limit of 15m with respect to 173.6m - which is the data point value.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FT2zSVWoXhBzzM8oI5Llm%2Fimage.png?alt=media&#x26;token=1bd7e5ac-29be-41d6-99f7-ef03b62e9bc1" alt=""><figcaption><p>Display - by value</p></figcaption></figure>

#### **2.3. By field**

Use measure values as upper and lower bounds. In this example, for each month, the 2024 Actuals value is the upper bound and the 2022 Actuals is the lower bound for the error bar.&#x20;

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F6bi5jqsgYg2YBsGKHvpK%2Fimage.png?alt=media&#x26;token=df51b149-58dc-4f1b-97d5-27b4be275ca5" alt=""><figcaption><p>Display - by field</p></figcaption></figure>

* **Relationship to measure**

**Absolute:**  As shown in the image above, the actual value of the measure is taken as the upper and lower bound for the error bar.

**Relative:** The error bars are plotted for a measure by adding its values to the upper and lower bound measure values. In this case, the 2024 Actuals(upper bound) and 2022 Actuals(lower bound) will be added to the 2023 Actuals to plot the error bar.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FT3iKHDo7SvvybkolJ7q1%2Fimage.png?alt=media&#x26;token=d786ac4b-dabc-4990-9a7f-8f3af8c94ea5" alt=""><figcaption><p>Relationship to measure - Relative</p></figcaption></figure>

#### **2.4. Make symmetrical**

When you enable this option, the difference between the upper and lower bounds of each error bar will be the same across all axis categories.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FTzaYWqzS2mFctv2T6UtI%2Fimage.png?alt=media&#x26;token=579435ad-831c-4b84-8631-bc4a1bcfb592" alt=""><figcaption><p>Make symmetrical</p></figcaption></figure>

### 3. Bar

The marker and color of the error bar can be customized.&#x20;

#### 3.1. Match series color

Enable this toggle to apply the same color as the series measure while plotting the error bars. Notice the color of the error bars for 2024 Actuals and 2023 Plan.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F0Q3FPtVtatesy7cwD55N%2Fimage.png?alt=media&#x26;token=e2d88dfd-15af-4e09-9b9e-59c4fb216a44" alt=""><figcaption><p>Match series color option</p></figcaption></figure>

#### 3.2. Line color

Set a custom color for the error bar.

{% hint style="info" %}
The Line and Marker color options will be enabled only when the 'Match series color' option is turned off.
{% endhint %}

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FYHWHScjD680h4zvBKE55%2Fimage.png?alt=media&#x26;token=ab8eede2-a3dd-46ca-938c-8442588ee365" alt=""><figcaption><p>Line color option</p></figcaption></figure>

#### 3.3. Marker color

Set the color of the whiskers/markers.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FW46zBk23Hm5RDmKBqBIL%2Fimage.png?alt=media&#x26;token=bf73bed3-6d1c-4965-a616-f054ebdbeef4" alt=""><figcaption><p>Marker color</p></figcaption></figure>

#### 3.4. Thickness

Set the width of the error line.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FAul9x3h7uuC1EYdbP8MA%2Fimage.png?alt=media&#x26;token=f34a7ef9-a54d-407c-a1a8-1b2950302965" alt=""><figcaption><p>Error bar thickness</p></figcaption></figure>

#### 3.5. Marker size

Set the size of the marker.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FJC5ZEfWx90dTGnbjpVzi%2Fimage.png?alt=media&#x26;token=6d69d123-74e0-4be7-9d3e-da03c6bcf84b" alt=""><figcaption><p>Marker size</p></figcaption></figure>

#### 3.6. Marker shape

Choose between line/circle/diamond/square/triangle shapes for the markers.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FjBwO7zAa1SHYO6JuZWLi%2Fimage.png?alt=media&#x26;token=ac569dc2-1bc6-4c84-a866-8695ab7c9c39" alt=""><figcaption><p>Marker shape</p></figcaption></figure>

### 4. Label

Enable the label toggle to display error bar data points.&#x20;

{% hint style="info" %}
Data labels take precedence over error bar labels. If there is an overlap, the error bar label will not be displayed.
{% endhint %}

#### 4.1. Match series color

Enable this toggle for the data label color to inherit the same color as the measure series.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F9lyKOJ0Wg5uVgmwFub4b%2Fimage.png?alt=media&#x26;token=b5ed415e-d46f-423a-9e1e-c9637a3d19b5" alt=""><figcaption><p>Match series color</p></figcaption></figure>

#### 4.2. Type

Choose between 3 label display options:

* **Absolute**: Shows the actual values of the upper and lower bounds.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FxtvplXeKyknNHbFP8yLE%2Fimage.png?alt=media&#x26;token=a81cb482-bfb5-449f-a5f0-2de677ae25f8" alt=""><figcaption><p>Absolute label</p></figcaption></figure>

* **Relative (numeric)**: Shows the numeric values of the upper and lower bounds with respect to each data point.

<div><figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FnB0yQRbm5rdrEiSjuMMt%2Fimage.png?alt=media&#x26;token=6fb701a4-82ce-4c6f-b5b4-51a9b325b395" alt=""><figcaption><p>Relative(numeric) labels for Percentage display</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FGzTMoqUNICUxQNl06mwE%2F2024-08-28_16h54_02.png?alt=media&#x26;token=4df4b033-6730-4d4b-b438-c7cffc167472" alt=""><figcaption><p>Relative(numeric) labels for Value display</p></figcaption></figure></div>

* **Relative (percentage)**: Shows the percentage values of the upper and lower bounds with respect to each data point.

<div><figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FzcXus3hGJ0HW2AEgEeXr%2Fimage.png?alt=media&#x26;token=3a72d610-3c90-49ec-b895-63161a514665" alt=""><figcaption><p>Relative(percentage) labels for Percentage display</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FfMs3KI6WM77bmWqbbEBG%2F2024-08-28_16h54_02.png?alt=media&#x26;token=24474d2b-3f0b-43a8-8c2c-7b09c492c0a5" alt=""><figcaption><p>Relative(percentage) labels for Value display</p></figcaption></figure></div>

#### 4.3. Format

Set the color and size of the error bar label font.

{% hint style="info" %}
The Format option will be enabled only when the 'Match series color' option is turned off.
{% endhint %}

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FfHKdya5a7KLFpvRWwGP7%2Fimage.png?alt=media&#x26;token=7fcbd8fb-9dd1-4cf4-9585-55a11e8cae0f" alt=""><figcaption><p>Label format</p></figcaption></figure>

#### 4.4. Background color

Highlight error labels with a custom background color.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FGiSzK6XvA4HjpJST2ReQ%2Fimage.png?alt=media&#x26;token=05df183e-f123-40ac-baf4-4389d7db9965" alt=""><figcaption><p>Label background color</p></figcaption></figure>

### 5. Error area

Plot an error band across axis categories by enabling the Error area toggle.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F3rMLomfzPIZlQm0nqkuf%2Fimage.png?alt=media&#x26;token=a45521bc-984c-414d-ad5c-549eb300e5cb" alt=""><figcaption><p>Error area</p></figcaption></figure>

#### 5.1. Match series color

Enable the toggle for the error area to be rendered in the same color as that of the series. You can also set the transparency factor.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FcabsuRUHdcW9YqVfnnOj%2Fimage.png?alt=media&#x26;token=f783808d-4a26-4225-bf81-482ecc631c7d" alt=""><figcaption><p>Match series color</p></figcaption></figure>

#### 5.2. Style

Choose between Fill/Line and Fill+Line. When choosing the *Fill* option, remember to disable the Bar toggle.

<div><figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F6ULafC1vF26VL9IhvIsR%2Fimage.png?alt=media&#x26;token=45275179-f315-44bc-aad3-d1407b2e5b1c" alt=""><figcaption><p>Line</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FuT2xSuJDFmkpm6xPdsGD%2F2025-02-03_18h40_09.png?alt=media&#x26;token=9fdae123-3952-4302-bda0-a0e141d8119c" alt=""><figcaption><p>Fill</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FjUCg5jzT1rCJR7lKrZ7u%2F2025-02-03_18h41_03.png?alt=media&#x26;token=5dee91e0-46e2-47ee-91b1-1a72bbcf32f9" alt=""><figcaption><p>Fill and line</p></figcaption></figure></div>

#### 5.3. Fill color

Set a custom fill color. The **Match series color** option needs to be disabled to set a custom color.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FjHXIsPRdJPAmx21OANYm%2Fimage.png?alt=media&#x26;token=2e32cc48-90ae-4ef1-9768-0a4fd175b539" alt=""><figcaption><p>Fill color for error area </p></figcaption></figure>

#### 5.4. Connect area through nulls

If your dataset contains null data points, you can choose to render the error area through the null points.
