Group Column
A Group Column Chart (also known as a Clustered Column Chart or Stacked Column Chart) extends the standard column chart by plotting numeric values for levels of two categorical variables instead of one.
Grouping: Columns are grouped by position for one categorical variable.
Color Coding: A secondary category is represented using different colors within each group.
This chart is useful for comparing multiple categories across dimensions, while also showing the contribution of each subgroup to the total.
Best Situations to Use
Use a Group Column Chart when you want to:
Compare relative values across groups based on a shared parameter.
Show part-to-whole relationships within groups (using stacked columns).
Visualize year-over-year, region-wise, or product-wise comparisons.
Handle both absolute comparisons (clustered view) and percentage comparisons (100% stacked view).
Example: To compare region-wise sales for 2012, a simple column chart works. But to also compare product sales within each region, a Group Column Chart provides a clear breakdown.
Properties of the Group Column Chart
General
Component Name: Unique identifier for the chart.
Left / Top: Position of the chart on the canvas.
Height / Width: Chart dimensions.
Initial Visibility: Toggle chart visibility on initial load.
Max Button: Enable maximize functionality.
Base Type: Select base design (e.g., plain, styled).
Chart Type: Choose chart type (e.g., 100% stacked, clustered).
Merge Sub Category: Combine sub-categories into a single group.
Bar Size: Define column thickness.
Animation: Enable rendering animation.
Tooltip
Show Tool Tip: Enable/disable tooltips on hover.
Configuration:
Default or Custom tooltip.
Use Component Formatter for consistent formatting.
Background Color, Opacity, Border Color.
Font Size, Box Width, Precision.
Highlighter: Highlight bars when hovered.
Background
Gradient Rotation: Adjust background gradient angle.
Opacity: Control background transparency.
Gradient: Choose gradient type/direction; add multiple colors.
Border / Border Color / Border Radius: Customize border design.
Shadow / Color / Transparency: Add shadow effects.
Stack Border: Set stack border color, width, and radius.
Title & Subtitle
Show Title Box: Enable or disable title container.
Title Settings: Font color, size, style, weight, alignment, family, decoration.
Title Bar Height: Adjust title bar height.
Description: Add descriptive text below the title.
Dataset Description: Auto-populate title from dataset mapping.
Sub-Title: Configure font, size, alignment, and decoration for sub-title text.
Axis Configuration
X-Axis
Show / Hide axis line.
Axis Line Color.
Category Text Wrap: Wrap text for categories.
Sub-Category Font Size / Text Wrap.
Label customization: font size, color, weight, family, style, decoration.
Label Rotation / Tilt for readability.
Axis Description text.
Show Dataset Description (dynamic axis label from dataset).
Y-Axis
Show / Hide axis line.
Axis Line Color.
Label customization: font size, color, family, weight, style, decoration.
Tilted Label option for readability.
Axis Description text.
Show Dataset Description (dataset-driven axis label).
Legend
Show Legend: Toggle visibility.
Font Properties: Adjust color, size, weight, family, style, decoration.
Hide on Load: Keep hidden when chart loads.
Formatter
Unit: Define measurement unit.
Precision: Number of decimal places.
Currency: Apply currency formatting.
Position: Place unit/currency before or after values.
Number Formatter: Select Indian or International style.
Axis Setup
Auto Axis Setup: Auto-adjust axis scaling.
Base Zero: Start axis at zero.
Min / Max Value: Set manual axis ranges.
Marker Lines: Add horizontal, vertical, or zero reference lines.
Zero Marker Color: Customize baseline color.
Opacity: Adjust axis and marker transparency.
Export Options
Context Menu: Enable right-click export options.
Supported Formats: Excel (.xlsx), CSV (.csv), JPEG (.jpg), PNG (.png), PPTX (.pptx), PDF (.pdf).
Print Option: Directly print the chart.
Export Metadata: Add heading, subheading, and filename.
Global Export Type: Choose default export type (Screenshot / Tabular).
Repeater
Repeater: Generate multiple charts for each unique category value.
Group By Field: Select grouping field.
No. of Columns: Define number of chart columns.
Row Height: Row height for repeated charts.
Column Margin / Row Margin: Adjust spacing between repeated charts.
Dataset Series Properties
Series Colors: Change color of each series.
Column Type: Switch series to Line or Column.
Chart Variants
The Group Column chart supports:
Stacked Columns (Plain base)
100% Columns (Plain base)
Clustered Columns (Plain base)
Dataset Mapping
When configuring the Group Column chart:
Category: e.g., Region.
Sub-Category: e.g., Items.
Series Fields: e.g., Sales, Revenue, Expenses
Example
Using the sample dataset:
Category: Region
Sub-Category: Items (Product A, Product B)
Series Fields: Sales and Revenue
The resulting Group Column Chart shows sales and revenue per region, with grouped bars for each product.