Menu
Amazon QuickSight
User Guide

Working with Horizontal Bar Charts

You can use the horizontal bar chart visual type to create a single-measure, multi-measure, or clustered horizontal bar chart. A single-measure bar chart shows one measure for one dimension, for example average delay time by flight number. A multi-measure bar chart shows two or more measures for one dimension, for example sales total and profit total by automobile mode. A clustered bar chart shows values for a dimension grouped by a related dimension, for example sales totals by automobile model, grouped by car maker.

To create a horizontal bar chart, use a dimension for the Y axis and a measure for the value. The dimension is typically a text field that is related to the measure in some way. You can use the dimension to segment the measure to see more detailed information. You can also use a date field in this way, but we recommend using a line chart for that because they are better suited to showing changes in a measure over time. Each horizontal bar in the chart represents a measure value for an item in the dimension you chose.

Horizontal bar charts show up to 2500 data points on the Y axis for visuals that don't use group/color. For visuals that do use group/color, they 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 bar chart is as follows:

Horizontal Bar Chart Features

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

Feature Supported? Comments For More Information
Changing the legend display Yes, with exceptions Multi-measure horizontal bar charts and clustered horizontal bar charts display a legend, while single-measure horizontal bar charts do not. Displaying the Visual Legend
Changing the title display Yes Displaying a Visual's Title
Changing the axis range Yes You can set the range for the X axis. Changing 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 on the chart, except when you are using a date field as the dimension for the Y axis. In that case, you can only focus on a bar, 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 field or fields you choose for the value, and can't apply aggregation to the fields you choose for the Y axis or group/color. 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 Bar Chart

Use the following procedure to create a horizontal 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 bar chart icon.

  4. From the Fields list pane, drag the fields 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 single-measure horizontal bar chart, drag a dimension to the Y axis field well and a measure to the Value field well.

    • To create a multi-measure horizontal bar chart, drag a dimension to the Y axis field well and two or more measures to the Value field well. Leave the Group/Color field well empty.

    • To create a clustered horizontal bar chart, drag a dimension to the Y axis field well, a measure to the Value field well, and another 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.