# 100 Percent Stacked Bar Graph

Version 15

## Intro

A 100% Stacked Bar graph is similar to a Stacked Bar graph in that categories are represented as bars and series as components of those bars. However, in a 100% Stacked Bar graph, each series bar represents the percentage of the overall category to which it belongs. For example, if a category was composed of three series, one with a value of 100, one of 200, and one of 300, the first series would make up 16.6% of the category (because 100 is equal to 16.6% of 600, the total value of all three series), the second would make up 33%, and the third 50%. In a way, then, a 100% Stacked Bar graph is also similar to a Pie graph, in which each bar corresponds to a pie.

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

By default the values on the y-axis appear with percent symbols. You can change this behavior in the Chart Properties if you want. For more information, see Formatting Values in Your Chart.

## Powering 100% Stacked Bar graphs

A 100% 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 100% 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 100% Stacked Bar 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 graphs

You can customize the appearance of a 100% Stacked Bar graph by editing its Chart Properties. For information about all chart properties, see Chart Properties. Unique properties of 100% Stacked 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.

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.