Box charts are used to analyze one or several data sets in the graphical view. This type of chart can be used to compare distributions between several data groups or sets. For each data group or data set the following calculations are made: center statistics (median, average) and range statistics (quartiles, standard deviations) for various periods of time and the selected values are displayed on the chart.
The complete data set is always used on plotting a chart. The chart displays the summary statistics of the data set calculated automatically.
A box chart consists of candles with body and whiskers:
The candle body is set by the upper and lower quartile and median.
The candle's whiskers are specified by the minimum and maximum values:
The lower whisker is built on the minimum point to the lower quartile.
The upper whisker is built from the upper quartile to the maximum point.
NOTE. The width of the candle bodies is calculated automatically. The line width of maximum and minimum is fixed.
Consider an example of the chart displaying summary statistics of data set calculated automatically. The source data "Exchange rate frequency, USD" for the chart:
Displaying of data as a box chart:
The following settings are available during chart editing:
See also:
Chart Types | Data Visualization as Charts