Error Bar
Last updated
Was this helpful?
Last updated
Was this helpful?
The Error Bar has 2 modes, Mean mode, and Ratio mode. The mode automatically switches depending on the column data type and aggregation function that you assign to Y-Axis.
If you assign a numeric column to Y-Axis and choose either "Mean" or "Conditional Mean" for the aggregation function, it becomes the Mean mode. The Error Bar calculation is based on the mean values.
If you assign a column and aggregation function that don't match the Mean mode criteria above, it becomes the Ratio mode. The Error Bar calculation is based on the ratio of the value counts.
X-Axis - Assign a column you want to show at X-Axis. If it's a Date / Time column assigned, you can select the aggregation level such as Month, Week, Day, etc. If you assign a Number column, you can choose either As Number to treat values as continuous values or As Text to treat values as categorical values.
Y-Axis - Assign a column you want to show at Y-Axis. The Error Bar mode automatically switches depending on the column data type and aggregation function. See "Mean mode and Ratio mode" above for details.
Range Type - You can select an error bar range type from the following options. The default is Standard Error.
Standard Error
90% Confidence Interval
95% Confidence Interval
99% Confidence Interval
1 Standard Deviation (Available only in Mean mode)
2 Standard Deviation (Available only in Mean mode)
3 Standard Deviation (Available only in Mean mode)
1.5 IQR (Available only in Mean mode)
Marker - You can select a marker type from the following options. The default is Bar.
Bar - Suitable for comparing actual values and error bar ranges.
Circle - Suitable for comparing error bar ranges.
Sort By - Assign a column to use for Sorting the X-Axis values. The default is based on either the alphabetic order or the factor level order for Factor type columns.
Orientation - You can choose a chart orientation. Either 'Vertical' or 'Horizontal'.
You can change the error bar styles from the "Style" setting at Y-Axis. You can change the following.
Line Width: Thickness of the error bars.
Circle Size: Size of the circle. Available only for the "Circle" marker option.
Horizontal Bar Width: Length of the horizontal bar part of the error bars.
If the Error Bar is in Ratio mode, you can set how to group by for the percentage calculation in the Ratio Setting dialog. You can reach the Ratio Setting dialog from the Y-Axis menu. The following group by options are available. The default value is X Axis.
Color - Take a look at section for more details.
Repeat By - You can assign a column to repeat the chart for each of its values. Take a look at section for more details.
Standard Error
95% Confidence Interval
99% Confidence Interval
Standard Error
95% Confidence Interval
99% Confidence Interval
Take a look at section for more details.
You can change the color of the specific markers such as bars, lines, or circles that you pick to stand out from others. See for the detail.
You can categorize numeric values inside the chart. See for the detail.
You can use Limit Values to filter the categories by the aggregated values. See for the detail.
If you have many categories, you can reduce the number of categories by changing some category names to 'Others' using the 'Others' Group feature. See for the detail.
X Axis - Calculate the ratio for each X-Axis and Color group. For example, the TRUE ratio of Africa and Corporate (Blue bar at Africa) is 4.5%.
Color - Calculate the ratio for each color value. The total percentage of each color value becomes 100%. For example, the total percentage of all the blue bars is 100%.
All - Calculate the ratio based on the entire data. The total percentage of all bars in all colors becomes 100%.
You can use the Missing Value Handling feature to control missing values. See for the detail.
You can show the detailed data underlying the chart by clicking the chart figure. See for the detail.
Take a look at on how to configure the layout and format.
You can save the chart as an image file. See for more details.
