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.

Apply to option

2. Stacked groups

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

Error bars for stacked/cluster charts

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.

Display - by percentage

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.

Display - by 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.

Display - by field

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

Relationship to measure - Relative

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.

Make symmetrical

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.

Match series color option

3.2. Line color

Set a custom color for the error bar.

The Line and Marker color options will be enabled only when the 'Match series color' option is turned off.

Line color option

3.3. Marker color

Set the color of the whiskers/markers.

Marker color

3.4. Thickness

Set the width of the error line.

Error bar thickness

3.5. Marker size

Set the size of the marker.

Marker size

3.6. Marker shape

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

Marker shape

4. Label

Enable the label toggle to display error bar data points.

Data labels take precedence over error bar labels. If there is an overlap, the error bar label will not be displayed.

4.1. Match series color

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

Match series color

4.2. Type

Choose between 3 label display options:

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

Absolute label

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

Relative(numeric) labels for Percentage display

Relative(numeric) labels for Value display

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

Relative(percentage) labels for Percentage display

Relative(percentage) labels for Value display

4.3. Format

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

The Format option will be enabled only when the 'Match series color' option is turned off.

Label format

4.4. Background color

Highlight error labels with a custom background color.

Label background color

5. Error area

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

Error area

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.

Match series color

5.2. Style

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

Line

Fill

Fill and line

5.3. Fill color

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

Fill color for error area

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.