ForumKB
Try it Free

Column Chart

A Column Chart compares values across categories using vertical columns. It is useful for comparing discrete categories and showing changes across an ordered category axis.

Column Chart

Configuring Data

Configure the Column Chart in the ASSIGN DATA tab. At least one field is required in Values.

Data section Requirement Description
Values Required Accepts one or more measures or numeric expressions. Each field is aggregated and plotted as a series.
Columns Optional Accepts one or more dimensions for the category axis. Multiple fields create a drill-down hierarchy.
Row Optional Accepts one dimension and splits each value into series based on its distinct values.
Hidden Column Optional Accepts measures or dimensions used for filtering, linking, or underlying data without plotting them.
Filters Optional Accepts measures or dimensions and applies additional filtering conditions.
Tooltip Optional Accepts one or more measures shown as supplementary tooltip values.

Assigning Data

  1. Drag the Column Chart from the toolbox onto the design canvas.
  2. Select the chart, click the Settings icon, and open the ASSIGN DATA tab.
  3. Add one or more measures or numeric expressions to Values.
  4. Optionally, add dimensions to Columns to group columns and create drill-down levels.
  5. Optionally, add one dimension to Row to split the values into additional series.
  6. Add fields to Hidden Column, Filters, or Tooltip as needed.

Multiple Values fields create multiple column series. A Row field creates a series for each distinct row value.

Settings menu

Click the More options icon for an assigned field to access Rename, Aggregation type, Sort, Filter(s), and Format, when supported. When Row is configured, Exclude Rows is available for eligible Sum and Count value fields. See Data Configuration for related field settings.

Drill Down

Widgets that support hierarchies enable drill-down when multiple dimension fields are assigned to the hierarchy data section. Select a data point to move to the next level, and use the widget breadcrumb to return to a previous level.

Formatting the Column Chart

You can format the Column Chart using the property categories listed below.

Basic Settings

Configure chart type and axis assignment, value labels, hover scaling, missing values, scrolling, column size, border, and corner radius. Refer to Basic Settings for more information.

Tooltip Settings

Configure tooltip visibility, content, color, direction, and shared display. Refer to Tooltip Settings for more information.

Legend Settings

Configure legend visibility, interaction, position, shape, title, and text behavior. Refer to Legend Settings for more information.

Series Palette

Configure series colors when Row is assigned. Refer to Series Palette for more information.

Refer to Linking for information about configuring navigation from a data point.

Axis

Configure category and value axes, secondary-axis behavior, formats, and axis ranges. Refer to Axis for more information.

Grid Lines

Configure primary, secondary, and category-axis grid lines. Refer to Grid Lines for more information.

Trendline

Add a trendline when the Column Chart has an eligible non-stacked data configuration. Refer to Trendline for more information.

Formatting

Configure series colors and eligible advanced color rules. Refer to Formatting for more information.

Font Settings

Refer to Font Settings for information about configuring chart fonts.

Filter

Refer to Filter Settings for information about configuring filter-related properties.

Container Appearance

Refer to Container Appearance for information about configuring the widget container.

Container Actions

Refer to Container Actions for information about configuring viewer actions.

No Data Appearance

Refer to No Data Appearance for information about configuring the chart when no data is available.

Export Settings

Refer to Export Options for information about configuring available export formats.

View Underlying Data

Refer to View Underlying Data for information about allowing viewers to inspect the chart’s underlying records.

AI-Powered Summarization

When available, this category controls whether viewers can generate a natural-language summary of the chart data.