Skip to main content
waffle.svg
Domo Knowledge Base

Nested Bar Graph

Intro

In a Nested Bar graph, the total values for all categories are represented as gray bars, and the values for all series are represented as smaller, colored bars and are shown side-by-side or stacked on top of each other within the bars for their respective categories. Vertical and horizontal subtypes are available for Nested Bar graphs.

Domo also includes a version of the Nested Bar graph with trendlines for comparison. For more information, see Nested Bar with Line Graph.

Powering Nested Bar graphs

A Nested Bar graph requires three columns or rows of data from your DataSet—one for categories, one for the series in each category, and one for values. For information about value, category, and series data, see Understanding Chart Data.

In the Analyzer, you choose the columns containing the data for your Nested Bar graph. For more information about choosing data columns, see Applying DataSet Columns to Your Chart.

For more information about formatting charts in the Analyzer, see KPI Card Building Part 2: The Analyzer.

The following graphic shows you how the data from a typical column-based spreadsheet is converted into a vertical Nested Bar graph:

The following graphic shows you how the data from the same column-based spreadsheet is converted into a horizontal Nested Bar graph:

Customizing Nested Bar graphs

You can customize the appearance of a Nested Bar graph by editing its Chart Properties. For information about all chart properties, see Chart Properties. Unique properties of Nested Bar graphs include the following. You can click a thumbnail image to see a larger image.

Property

Description

Example

General > Sort Each Category

Allows you to sort the items in each individual category in most kinds of multi-series Bar and Lollipop charts. You can choose an ascending or descending sort. If you select Default, the default sort is applied. This option does not work when the Value Scale > Log Scale box is checked.

In the example at right, bars within all categories are sorted in descending order. 

General > Sort on Totals

Allows you to sort categories in many kinds of Bar and Lollipop charts by their total values, in either ascending or descending order. If you select Default, the default sort is applied. This option does not work when the chart has automatic time scaling applied. (You can turn off automatic time scaling by checking the box for Category Scale > Never Use Time Scale.

In the example at right, the categories are sorted by their totals in ascending order.

General > Maximum Bars

Allows you to specify the number of bars that appear in your Bar chart. Data for all remaining bars is lumped into a single "Other" bar (unless you hide this bar using the Hide 'Other' Bar toggle.

The example at right shows a Bar chart in which the maximum number of bars has been set to 7.

maximum_bars.png

General > Hide 'Other' Bars

Hides or shows the "Other" bar that appears when you set a maximum number of bars using the Maximum Bars option.

General > Group Legend Text

Lets you specify the legend text for the "group bars" (the vertical gray bars that show the totals for each category). In the example, the default group bar legend text has been replaced with the words "Grand Total."

General > Hide Group in Legend

Hides the legend text for the "group bars" (the vertical gray bars that show the total for each category.

Data Label Settings >  Show Group Total

Determines whether data labels appear over the gray "total" bars in Nested Bar charts. The chart at right shows an example of this.

show_group_total.png