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.

One error bar can be created per measure.

1. Apply to

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

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