Error bar
Last updated
Last updated
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.
Select the measure for which the error bar should be plotted.
Error bars can be plotted based on a user-specified percentage or value or based on measures.
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.
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.
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.
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.
The marker and color of the error bar can be customized.
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.
Set a custom color and thickness for the error bar.
The Format and Marker options will be enabled only when the 'Match series color' option is turned off.
Set the thickness and color of the whiskers/markers.
Choose between line/circle/diamond/square/triangle shapes for the markers.
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.
Enable this toggle for the data label color to inherit the same color as the measure series.
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.
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.
