Stacked Column Chart Properties

Data Binding Tab

The Data Binding tab is where you connect your dataset to the chart, defining how your data fields map to various parts of the visualization. For the Column Chart, the following data binding slots are available:

• Upper Value

  Bind the data field representing the upper limit or maximum value for a data range or band in your chart. This is often used in visualizations like range columns or banded charts to highlight the upper boundary of a data interval.

• Lower Value

  Bind the data field representing the lower limit or minimum value for a data range or band. This complements the Upper Value to define the lower boundary of the data interval shown in the chart.

• Axis (Category)

  Place the data fields here that you want to display on the Category Axis (typically the vertical axis). This is often referred to as the Y Axis and usually contains categorical data such as product names, regions, or time periods.

• Legend (Series)

  Use this slot to assign data fields that differentiate series within the chart. The legend displays these categories, enabling viewers to distinguish between multiple data series by color or pattern (e.g., different product lines or regions).

• Trellis Columns

  Use this slot to create multiple copies of the chart arranged in columns, each filtered by a unique value from the selected data field. This allows for side-by-side comparisons across different subsets of your data, such as multiple years or regions.

• Trellis Rows

  Similar to Trellis Columns, this slot creates multiple copies of the chart arranged in rows. It lets you compare subsets of your data vertically based on a selected field.

• Tooltip

  Place data fields here to add detailed information displayed when hovering over chart elements in the preview or final dashboard. Tooltips provide additional context without cluttering the main visualization.

• Drill Down Mode

  Configure how users can interactively explore data by drilling down into details. You can set the drill down mode to either:

  • Pre-set Targets: Specify specific fields that users can click on to drill down to more detailed views.

  • Pre-set Paths: Define a sequence of fields representing a hierarchical path for drill down, allowing users to navigate through multiple layers of data detail.

  After selecting a mode, specify the drill down targets or the drill down path fields accordingly

Customization Options

Column charts in Wyn can be extensively styled and configured using the Inspector panel. Below are key settings you can modify:

Chart Style

Maintain Color Assignments: Toggle this to True if you want to manually assign specific colors to individual data values instead of using automatic color mapping.

Palette: Lets you customize the color scheme applied to the chart. Use the dropdown to choose from available color palettes based on the current Theme.

Graph Opacity: Controls the transparency of the chart. Set to 0% for fully transparent or 100% for fully opaque.

Auto Gap Width: Enabled by default. This controls the spacing between columns. To manually define the gap width, switch this setting to False.

Corner Radius: Adjusts the roundness of the corners on columns or bars. Use the arrow controls to set the radius for each edge.

Auto Gradient: When enabled, applies a gradient effect to the chart colors for a more dynamic visual appearance.

Padding: Adds space around the chart to separate it from the edges of the scenario or dashboard layout.

Data Visualization

• Top N Grouping – When enabled, limits the displayed data to the top N items based on a chosen measure (e.g., top 10 categories by sales). This is useful for focusing on the most significant data points.

  • Additional Option: When this setting is turned on, a Show property appears, allowing you to enter a numeric value for N (the number of top items to display).

  • Default: Off.

• Include All Dimensions – When enabled, ensures that all available dimension values are included in the visualization, even if they have no corresponding measure values. This can help maintain consistent category representation across views. Default: Off.

Data Labels

• Show Data Label: Toggle this on to enable data labels on the chart.

• Display Pattern: Choose a label structure from:

  • Category

  • Series (Value)

  • Category Series Value

  Note: This controls the format, but not which elements are shown.

• Toggle Visibility for Each Element:

  • Value – must be set to true to display values.

  • Series Name – toggle on to display the series name.

  • Category Name – toggle on to display the category.

• Display Mode: Set to All to show all enabled elements together.

• Label Location: Choose between On Slice or Around.

• Same Color as Legend: Toggle on to match the label color with the legend entry.

• Font Settings (same as title):

  • Font family, size (pt), color, weight, and italic styling.

• Show Shape: Toggle on to add a background shape to the label.

  • Upload a Shape Image.

  • Adjust placement and size with:

    • Shape X Center

    • Shape Y Center

    • Shape X Scale

    • Shape Y Scale

Tooltip

Tooltip Mode – Determines how tooltips are displayed when hovering over the chart:

• None – Disables tooltips.

• Data Point (default) – Shows a tooltip for the specific data point under the pointer.

• Category – Shows a tooltip for all data points that share the same category value.

Show Category Tracking Area – Highlights the entire area of the chart that corresponds to the hovered category, helping visually connect related data points.

Show Category Tracking Line – Draws a vertical or horizontal line (depending on chart orientation) across the chart at the hovered category to make it easier to see alignment across series.

Show Point Cross Value Axis – Draws a line from the hovered point to the value axis, making it easy to identify the exact value.

Show Point Cross Category Axis – Draws a line from the hovered point to the category axis, making it easy to identify the exact category.

Axis (Category)

The Category (Y) Axis settings give you full control over the vertical axis of the chart.

• Show Axis: Enabled by default. Toggle off to hide the Y-axis entirely.

• Axis Position: Set the axis placement using the dropdown options: Zero, Bottom, or Top.

Axis Line and Grid

• Show Axis Line: Enabled by default. Controls the visibility of the axis line. You can customize its line type(Solid or Dashed), color, and width.

• Show Grid Lines: Disabled by default. Enable to add horizontal grid lines across the chart, and customize their type, color, and width.

• Show Split Area: Disabled by default. Toggle on to highlight alternating background bands, and define Odd Area Color and Even Area Color.

Labels and Tick Marks

• Show Tick Labels: Enabled by default. Use this toggle to show or hide the axis labels.

• Label Direction: Choose how labels are displayed: Horizontal, Vertical, or Diagonal.

• Label Overflow: Define how long labels behave when space is limited: Hide, Ellipsis, or Wrap.

• Show Tick Marks: Enable this toggle to display tick marks along the axis.

Title and Font Styling

• Show Title: Disabled by default. Turn this on to add a title to the Y-axis. Use the Title Offset property to adjust the spacing between the title and the axis.

• Axis Font Settings: Customize the appearance of axis labels and title by adjusting the font family, size, color, weight, and style.

Value Axis

The Value (X) Axis settings let you configure the numerical axis of your chart, typically displayed horizontally.

• Show Axis: Enabled by default. Toggle this off to hide the entire axis.

• Min Value / Max Value: Define a fixed range for the axis.

• Interval: Set custom spacing between tick marks.

• Reversed: Flip the axis direction (e.g., highest values on the left). Disabled by default.

• Axis Position: Choose whether the axis appears at the Top or Bottom of the chart.

Axis Line and Grid

• Show Axis Line: Enabled by default. Controls the visibility of the axis line. Customize the line’s type (Solid or Dashed), color, and width.

• Show Grid Lines: Disabled by default. Enable to display horizontal lines across the chart. You can customize their line type, color, and width.

• Show Split Area: Highlight alternating vertical bands by setting Odd Area Color and Even Area Color.

Labels and Tick Marks

• Show Tick Labels: Enabled by default. Toggle this to show or hide labels along the axis.

• Format: Choose how labels are displayed (General, Number, Currency, Percentage, or Custom).

• Display Unit: Scale values using Auto, None, Thousands, Millions, etc.

• Label Direction: Set label orientation to Horizontal, Vertical, or Diagonal.

• Show Tick Marks: Toggle to display or hide the tick marks themselves.

Title and Units

• Show Title: Disabled by default. Enable this to add a title to the axis and adjust its position using the Title Offset.

• Show Unit's Label: Enable this option to display a unit label (e.g., USD, %).

Font Customization

• Axis Font Settings: Customize the axis text by choosing the font family, size, color, weight, and style.

Legend

By default, the Show Legend toggle is set to True, which displays the legend on the chart. To include a title for the legend, enable the Title toggle as well. You can customize the title by setting the Font Family (e.g., Arial), Font Size, Text Color, Font Weight (such as bold), and applying Italic styling if desired.

The Title Alignment property allows you to position the legend title to the left, center, or right of the chart area.

The legend is set to Auto Size by default. To manually define the legend size, disable this setting by setting Auto Size to False. You can also control the Horizontal and Vertical Alignment, which are both set to Auto by default but can be changed using dropdown options. To allow legend labels to wrap across lines, set the Wrap Legend option to True.

Series

Trellis

Use the Trellis properties when you create a Trellis Chart. This can be done in the Data Binding Tab. Drag and drop the attribute to Trellis. You can read the Trellis Column Chart article for more information.

You can set the Padding around the Trellis Chart to control the spacing between the chart content and its edges. You can also define a Trellis Border Colorto outline each panel of the trellis. Additionally, the Trellis Font Settings allow you to customize the font family, size, color, weight, and style of the text used in the trellis layout.

Drill Down Setting

• Position – Determines where the drill-down navigation bar is displayed on the chart. Options include:

  • Top left (default)

  • Top center

  • Top right

  • Bottom left

  • Bottom center

  • Bottom right

• Home Name – Specifies the text label for the top-level view in the drill-down hierarchy. The default label is Home, but you can change it to something more descriptive, such as All Regions or Main Category.

• Font – Configures the font family, size, color, weight (e.g., bold), and style (e.g., italic) for all drill-down navigation text.

• Current Level Font Color – Sets the color for the label of the currently active drill-down level, helping it stand out from other levels.

• Other Levels Font Color – Sets the color for labels representing all non-active drill-down levels, allowing users to visually distinguish between the active and inactive levels in the navigation path.