Error Bar
Last updated
Last updated
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.
Color - Take a look at Color section for more details.
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.
Repeat By - You can assign a column to repeat the chart for each of its values. Take a look at Repeat By section for more details.
Orientation - You can choose a chart orientation. Either 'Vertical' or 'Horizontal'.
Take a look at Reference Line section for more details.
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.
You can change the color of the specific markers such as bars, lines, or circles that you pick to stand out from others. See Highlight for the detail.
You can categorize numeric values inside the chart. See Category(Binning) for the detail.
You can use Limit Values to filter the categories by the aggregated values. See Limit Values 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 'Others' Group for the detail.
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.
You can use the Missing Value Handling feature to control missing values. See Missing Value Handling for the detail.
You can show the detailed data underlying the chart by clicking the chart figure. See Show Detail for the detail.
Take a look at Layout Configuration on how to configure the layout and format.
You can save the chart as an image file. See Save as PNG/SVG for more details.
Standard Error
95% Confidence Interval
99% Confidence Interval
Standard Error
95% Confidence Interval
99% Confidence Interval
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%.
