Skip to main content
Version: 9.3

Multiseries Bar Chart

Use Multiseries Bar Charts to present a single value in more than one category. Effectively, a Multiseries chart consists of two dimensions and a measure.

Multiseries Bar Charts compare aggregated values in your data throughout the series field.

ms-bar-chart

Create a Multiseries Bar Chart​

To create a Multiseries Bar Chart, drag and drop a data field from the Data Panel onto either the corresponding shelf or the canvas.

The following use case visualizes the order quantities in different statuses of shipments per country of the order. The value of each Category is represented by the size of the respective bar. Each value in the Series is represented by a color that can be distinguished by adding a legend to the chart.

  1. Drag and drop the following:

    • country as Category
    • quantity as Values
    • status as Series

  2. Continue styling the chart in the Configuration Panel to produce the visualization.

ms-bar-chart

If you have only one category to visualize, you can use a Bar Chart.

Style the Multiseries Bar Chart​

In the Configuration Panel on the right of the Chart Builder, you can style different aspects of your chart.

General​

The General section is available for all chart types, and the options vary depending on the chart selected.

Note: Use the Table Calculations option to add calculations to your chart. For more information, see Table Calculations.

Styles​

The Styles section enables you to control various visual elements of the charts, such as colors, labels, and more. It is available for most chart types, and the options vary depending on the chart selected. Style options specific to this chart are listed below.

  • Theme - Set one of the predetermined themes for a more unified look of your charts.

    • Match colors across charts - Select to unify the colors of each categorical value throughout the page and application.

  • Axis Labels - Show or hide the labels of the axes.

  • Category axis (normally the X-axis)

    • Label - Give the axis a custom label.
    • Values - Show or hide values on the axis.
    • Values Rotation - If values are enabled, decide how you want them to be displayed.

  • Values axis (typically y axis)

    • Label - Give the axis a custom label.

    • Values - Show or hide values on the axis.

    • Values Rotation - If value labels are enabled, decide how you want them to be displayed. You can use this option to avoid overlapping labels.

    • Format - Select a value format: Default, Abbreviated, Decimal (set the number of decimal points), Currency (select the currency from the drop-down menu and set the number of decimal points), Percentage (set the number of decimal points), Scientific. Values can also be formatted from the Values column pill.

    • Scale Type - the default scale type is Linear; however, a linear scale is not appropriate for data that is spread over a wide range. Use the Logarithmic scale to display numerical data over a wide range of values in a compact way.

    • Min Range - Set the minimum value for the axis.

    • Max Range - Set the maximum value for the axis.

    • Steps - Depending on the width of the axis range, the default configuration could display many tick marks, affecting readability. Intervals are set to Auto by default. The chart calculates the appropriate intervals based on the axis scale range and the dataset values. In the following example, the range of data is from 0 to 8,000. When set to 1000 units, the chart displays eight tick marks. When set to 10,000, the chart only displays one tick mark.

      ms-bar-chart

      When the axis range is wide (for example, 0-10,000,000), setting the 'Steps' option to 1 will create 10 million tick marks, causing performance issues. To avoid this situation, the chart ignores the defined value and reverts to automatic mode.

  • Bar Width - Bar width is set to Auto by default. The system adjusts the percentage to what it sees as most appropriate considering the size of the chart. If the width is set to 100%, the bars use all of the chart’s space, leaving no gap between the bars. Select a width percentage other than 0 to decide the width of each bar and the gaps. Set the percentage to 0 to revert to automatic mode.

  • Type - Select stacked (all Series values displayed in the same column), cluster (Series values are represented by individual bars side-by-side), or 100% (bars extend to the top of the Y-axis, representing each Series as the percentage of the total, rather than value).

  • Data Labels - Enable or disable data labels to show specific values directly on the chart for easier reference.

    • Borders - Control if the values displayed have a border or not.

  • Offset - Determines the offset of the chart. Select whether to configure a manual offset as a Percentage or in Pixels, and enter values in the Left and Top/Bottom fields. To enable the platform to automatically manage the offsets, select Reset to Default to set the values under Left and Top/Bottom to Auto.

    ms-bar-chart

Sorting​

Like all Multiseries Charts, you can sort by either the category or aggregated values from the column pills. If the column is not included in the chart, go to the Sorting section of the Configuration Panel and select a column from the dropdown, then select the sorting direction.

For more information, see Sorting.

Layers​

Add a Trend Line or a Reference Line to your chart to allow users to visually compare the data against a defined trend or reference value.

Format​

The Small Multiples feature is available in all XY Charts. You can apply Conditional Formatting to your Multiseries Chart.

Filters​

You can also add Filters to your data by expanding the Filters section in the configuration panel or by selecting the Filters button in the toolbar above the canvas. Filters that are created in the Chart Builder are hidden from end users. You cannot edit or interact with these filters in view mode.