Skip to main content
waffle.svg
Domo Knowledge Base

Grouped and Stacked Bar Graph

Version 15

 

Intro

A Grouped and Stacked Bar graph combines the features of a Grouped Bar graph and a Stacked Bar graph. Categories in Grouped and Stacked Bar graphs always consist of two bars shown side-by-side, as in a Grouped Bar graph. When categories contain more than two series, one of these two bars appears as a typical bar, but the other is divided into series segments, as in a Stacked Bar graph. This may be useful in situations when you want to compare a primary series (such as a series representing sales data for your company headquarters) against several secondary series (such as those series representing sales data for branch offices).

Grouped and Stacked Bar graphs have both vertical and horizontal subtypes. Another related graph, the Grouped and Stacked Bar with Line graph, combines the features of a vertical Grouped and Stacked Bar graph and a Stacked Bar with Line graph. For more information about Grouped and Stacked Bar with Line graphs, see Grouped and Stacked Bar with Line Graph.

By default, the first bar in any category grouping in a Grouped and Stacked Bar graph appears as a normal, undivided bar, and the second bar in the category grouping is divided into series segments. However, you can change this default behavior in Chart Properties by entering the number of series you want to appear in the first bar. For more information, see Customizing Grouped and Stacked Bar graphs.

Powering Grouped and Stacked Bar graphs

A Grouped and Stacked Bar graph requires three data columns or rows 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 Grouped and Stacked 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 Grouped and Stacked Bar graph:

The following graphic shows you how the data from a typical column-based spreadsheet is converted into a horizontal Grouped and Stacked Bar graph:

Customizing Grouped and Stacked Bar graphs

You can customize the appearance of a Grouped and Stacked Bar graph by editing its Chart Properties. For information about all chart properties, see Chart Properties. Unique properties of Grouped and Stacked Bar graphs include the following:

Property

Description

Bar Settings > First Bar Series Count

Lets you specify how many series make up the first bar of any category. The default setting for this property is 1, meaning the first bar is made up of only one series, and the second bar is divided up into all the remaining series. If you change this value, the first bar is divided into the indicated number of series, and the second bar is adjusted accordingly. For example, if a category contained three series, by default the first bar would contain one series and the second would contain the other two. However, if you entered 2 for First Bar Series Count, the first bar would be divided into two series, and the second bar would contain only one.

Value Scale > Title Position

Determines whether value scale labels in Vertical Bar charts appear to the left of the chart or above it.

Note: This property is deprecated as of our October 2016 release.