An Overlay Bar graph is similar to a standard Stacked Bar graph except that instead of being stacked, all series items begin from the baseline, so overlapping of series items occurs in a category when multiple series are present. In its initial non-rollover state, an Overlay graph is rather meaningless, as shown in the following example:
However, by mousing over a series item in the legend, you can see just that series in the chart, as shown in the following example:
In many applications this may be more useful than a Stacked Bar because you can more quickly compare series items in different categories. (In a Stacked Bar this is difficult because series in different categories do not usually begin from the same baseline.)
Overlay Bar graphs include both vertical and horizontal sub-types.
Powering Overlay Bar graphs
An Overlay 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 Overlay 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 Overlay Bar graph:
The following graphic shows you how the data from a typical column-based spreadsheet is converted into a horizontal Overlay Bar graph:
Customizing Overlay Bar graphs
You can customize the appearance of an Overlay Bar graph in a number of ways. Many customizations are possible by setting Chart Properties. For information about all chart properties, see Chart Properties.