Skip to main content
Wave Success Center by McKinsey

Stacked Chart View

With stacked chart view, you can aggregate and visualize quantitative measures across initiatives and milestones using bars and lines to view and compare values. You can also drill into detailsfilter data further within the view, view positive and negative values, and visualize cumulative impacts across a time period.

Stacked_Chart_screenshot.png 

If you are not already in stacked chart view, start by selecting Switch to stacked chart from the visualization icon in the upper left corner. 

Switch_stacked.png

Navigating Stacked Chart View

Unlike pivot, list and Gantt chart views, stacked charts have the added ability to apply aggregations to your view. 

Bar and Line Measures 

Generally, the bar measure is used to show actual data and the line measure is used to show planned impacts. In the example below, the bar measure of recurring benefits is compared to the line measure of planned recurring benefits.  

Stacked chart bar line.gif

 

You can also opt to view the values of the bar segments. Simply click on Display segment values in the Bar measure menu as illustrated below.

Display_segment_values.png

 

Customize View

As with other views you, can sort, filter, group, and color to further customize your stacked chart. In this example, initiatives are grouped into workstreams and colored by initiative status in order to see how the actual recurring benefits compare to actual, as well as the general status of initiatives. 

Stacked chart filter sort.gif

 

Dotted and Dashed Lines

Should you wish to compare multiple measures, you can display dotted or dashed lines in addition to a solid line in your stacked chart. Simply select Set dashed line or Set dotted line in the stacked chart menu. In the example below, planned, actual, and forecast data are visible for side-by-side analysis with solid and dotted lines.

Dotted line stacked chart.gif

 

View Details

Drill into the details of your stacked chart data by right- or left-clicking on a bar segment. The contextual menu will open and you can see the value of the bar, as well as the option to view details in a list view (new tab). If you select view details, a new tab will open in list view and you will be able to review the data associated with that segment of the stacked chart. In the example, the new tab is a list of all planned initiatives for Juices. 

You can also skip the contextual menu and open the details tab directly by double-clicking a data segment, as demonstrated below for planned initiatives in Juices. The initiatives shown will match the filter on both the lane and color segment clicked. The only exception is if the lane is a specific month from a group by period, where only the color filtering would apply.

Stacked chart drill down 1.gif

 

Filter 

In stacked chart view, you can filter your data by color or by group. Access the contextual menu by right- or left-clicking a data segment and select Filter by color or Filter by group. Please note that choosing a filter changes the view in your active tab and does not open a new tab; you can return to the previous view by clicking your browser's back button.

Filter by color

As in the example below, when Filter by color, the resulting visual is of all planned initiatives across the selected workstreams.

Stacked chart drill down 2.gif

Filter by group

Data can be filtered by group in one of two ways. You can select Filter by group from the contextual menu to limit the view to the specified group, in this case Juices. You can also click the Y-axis category, which in this example is Juices, at the bottom of the view. 

Stacked chart drill down 3.gif

 

Negative Impacts

Negative impacts in stacked charts can be viewed in two ways: as a solid blue bar or split between positive and negative values. Please note that the split is not possible when using butterfly coloring.

Blue bar

When a chart has a Colored By attribute selected, categories that have negative values will show as a solid blue bar with no other colors visible, as seen below for Sales. Additionally, an alert will appear in the breadcrumb for the bar measure when negative values are present. Please note that total for that bar will include both negative and positive values.

Blue_bar_and_breadcrumbs.png
Split positive and negative

To understand how the negative and positive values are spread, select the Split [+] and [-] values toggle option in the bar measure menu. When it is on, the bar will reflect the Color By attributes and show both negative and positives values, as illustrated below.

split_by_color.png

You can also activate the color split by clicking on the blue bar and selecting Split [+] and [-] colours from the menu.

split_plus_and_minus.png

 

Cumulative Impacts

Stacked chart view can also illustrate the cumulative impacts of a workstream or program. Both lines and bars can be set to show cumulative impact by selecting the Cumulative button. 

In the example below, the view shows cumulative benefits through the end of a program (bars, colored by stage) compared to the planned cumulative benefits (line). 

Stacked chart cumulative.gif

  • Was this article helpful?