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.

1. Apply to

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

2. Stacked groups

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

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.

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.

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.

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

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.

3. Bar

The marker and color of the error bar can be customized.

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.

3.2. Line color

Set a custom color for the error bar.

3.3. Marker color

Set the color of the whiskers/markers.

3.4. Thickness

Set the width of the error line.

3.5. Marker size

Set the size of the marker.

3.6. Marker shape

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

4. Label

Enable the label toggle to display error bar data points.

4.1. Match series color

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

4.2. Type

Choose between 3 label display options:

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

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

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

4.3. Format

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

4.4. Background color

Highlight error labels with a custom background color.

5. Error area

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

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.

5.2. Style

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

5.3. Fill color

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

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.