Amazon QuickSight
User Guide

Working with Horizontal Stacked Bar Charts

Use a horizontal stacked bar chart to show values for hierarchical data, for example sales total by car model, stacked by car maker. A horizontal stacked bar chart uses a scale based on the maximum value for the selected measure. To create a chart that uses a scale based on 100 percent instead, use the Working with a Horizontal Stacked 100 Percent Bar Chart.

Horizontal stacked bar charts show up to 50 data points on the Y axis and up to 50 data points for group/color. For more information about how we handle data that falls outside display limits, see Display Limits in Visuals.

The icon for a horizontal stacked bar chart is as follows:

Horizontal Stacked Bar Chart Features

Use the following table to understand the features supported by horizontal stacked bar charts.

Feature Supported? Comments For More Information
Changing the legend display Yes Customizing the Visual Legend
Changing the title display Yes Customizing a Visual Title
Changing the axis range Yes You can set the range for the X axis. Changing the Visual Scale with the Axis Range
Changing the visual colors Yes Changing Visual Colors in Amazon QuickSight
Focusing on or excluding elements Yes, with exceptions You can focus on or exclude any bar or color block within a bar, except when you are using a date field as one of the dimensions. In that case, you can only focus on the bar or color block that uses the date dimension, not exclude it.

Focusing on Visual Elements

Excluding Visual Elements

Sorting Yes You can sort on the fields you choose for the Y axis and the values. Sorting Visual Data in Amazon QuickSight
Field aggregation Yes You must apply aggregation to the fields you choose for the value and group/color, and can't apply aggregation to field you choose for the Y axis. Changing Field Aggregation
Adding drill-downs Yes You can add drill-down levels to the Y axis and Group/Color field wells. Adding Drill-Downs to Visual Data in Amazon QuickSight

Creating a Horizontal Stacked Bar Chart

Use the following procedure to create a horizontal stacked bar chart.

  1. On the analysis page, choose Visualize on the tool bar.

  2. Choose Add on the application bar, and then choose Add visual.

  3. On the Visual types pane, choose the horizontal stacked bar chart icon.

  4. From the Fields list pane, drag the fields that you want to use to the appropriate field wells. Typically, you want to use dimension or measure fields as indicated by the target field well. If you choose to use a dimension field as a measure, the Count aggregate function is automatically applied to it to create a numeric value.

    To create a horizontal stacked bar chart, drag a dimension to the Y axis field well, one measure to the Value field well, and one dimension to the Group/Color field well.

  5. (Optional) Add drill-down layers by dragging one or more additional fields to the Y axis or Group/Color field wells. For more information about adding drill-downs, see Adding Drill-Downs to Visual Data in Amazon QuickSight.