Home / Statistical Tools / Analysis Tools / Barchart / Options
Options¶
The Options tab in the Bar Chart dialog lets you customize the chart type, aggregation function, and display settings.
Report Type¶
Individual Charts¶
Creates a separate chart for each data column (categorical) or each data-frequency combination. This is the default mode and works with any number of frequency columns.
Cluster Chart¶
Groups multiple frequency columns as side-by-side bars within each category. Only available when 2 or more frequency columns are selected. Use this to compare different frequency measures across the same categories.
Stacked Chart¶
Stacks multiple frequency columns on top of each other within each category. Positive values stack upward from zero, negative values stack downward. Only available when 2 or more frequency columns are selected. Use this to see both the total and the composition of each category.
Function¶
Controls how values are aggregated into bar heights. The available functions change based on your data type and frequency selection.
| Function | Description |
|---|---|
| Count | Count of observations (or sum of frequencies when a frequency column is used). |
| Sum | Sum of values, or weighted sum when frequency is used. Default for numeric data and categorical data with frequency. |
| Mean | Average of values, or weighted mean with frequency. |
| Median | Middle value, or weighted median with frequency. |
| Min | Minimum value in each group or column. |
| Max | Maximum value in each group or column. |
| Standard Deviation | Sample standard deviation. Requires at least 2 observations. |
Function Availability
- Categorical data without frequency: Only Count is available.
- Categorical data with frequency: All functions except Count are available. Sum is the default.
- Numeric data (with or without frequency): All functions are available. Sum is the default.
Display Text Report¶
When checked, creates a summary table alongside the chart showing each category's value and percentage of total. Enabled by default.
Sort Datasets¶
When creating multiple charts, this controls the order in which they appear:
| Option | Description |
|---|---|
| Don't Sort | Charts appear in the order they were selected (default) |
| Sort by Name Ascending | Charts ordered A to Z by title |
| Sort by Name Descending | Charts ordered Z to A by title |