Skip to main content
waffle.svg
Domo Knowledge Base

100 Percent Stacked Bar with Line Graph

Intro

A 100% Stacked Bar with Line graph is similar to a 100% Stacked Bar graph in that each series bar in a stack represents the percentage of the overall category to which it belongs. The difference is that it also includes one or more trendlines and two y-axes, similar to other kinds of line-bar combination graphs. One of these is used to measure the values along the line(s), and the other is used to measure the percentages of the bars in each stack. By default, the first item that appears in your graph legend is represented as the line and all remaining items are represented as stacks of bars. You can change this behavior in the Chart Properties if you want. 

Both vertical and horizontal versions of 100% Stacked Bar with Line graphs are available. In vertical 100% Stacked Bar with Line graphs, series in categories are "stacked" on top of each other; in horizontal 100% Stacked Bar graphs, the series appear side by side.

Powering 100% Stacked Bar with Line graphs

A 100% Stacked Bar with Line 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 100% Stacked Bar with Line 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 100% Stacked Bar with Line graph:

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

Customizing 100% Stacked Bar with Line graphs

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

Property

Description

Example

General > Series on Left Scale Determines how many series in your graph appear as lines (or symbol series in a Stacked Bar with Symbols graph). By default, the first series that appears in your legend for these chart types becomes a line, and all remaining series become bars. However, you can convert series from bars to lines by entering the desired number of lines in Chart Properties. For example, if your chart had three series, the first series appearing in your legend would appear as a line, and the remaining two series would appear as bars. You could turn the second series into a line by entering 2 in the Series on Left Scale field.
General > Line Style

Lets you change the line style in your graph. By default, lines in line-bar combination graphs appear angular. If you want, you can change the line style to be curved, plain with symbols, curved with symbols, or consist only of symbols. 

The example shows a chart in which the line style has been set to Curved.

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. 

Bar Settings > Non-Stacked Interactivity

Turns off the default Stacked Bar graph interactivity.

When you hover over any series in a Stacked Bar or 100% Stacked Bar graph, all of the corresponding series are highlighted and connected across the graph, as shown in the first screenshot at right. However, if series data is missing for any stack in the graph, the highlighting is removed and a "0" appears in the stack, as shown in the second screenshot. By checking Non-Stacked Interactivity, the connecting lines, highlighting, and "0" no longer appear upon hover, as shown in the third screenshot.

For more information about DataSet columns, see Applying DataSet Columns to Your Chart.