Tableau Desktop and Web Authoring Help

Use bar charts to compare data across categories. You create a bar chart by placing a dimension on the Rows shelf and a measure on the Columns shelf, or vice versa.

A bar chart uses the Bar mark type. Tableau selects this mark type when the data view matches one of the two field arrangements shown below. You can add additional fields to these shelves.

For more information about the Bar mark type, see Bar mark.

Note: At the end of the procedure, there is an extra step you can take to display totals at the tops of the bars.

Creates Vertical Bars	Creates Horizontal Bars

To create a bar chart that displays total sales over a four-year period, follow these steps:

1. Connect to the Sample - Superstore data source.



Note: In Tableau 2020.2 and later, the Data pane no longer shows Dimensions and Measures as labels. Fields are listed by table or folder.

2. Drag the Order Date dimension to Columns and drag the Sales measure to Rows.

Notice that the data is aggregated by year and column headers appear. The Sales measure is aggregated as a sum and an axis is created, while the column headers move to the bottom of the view. Tableau uses Line as the mark type because you added the date dimension.



3. On the Marks card, select Bar from the drop-down list.



The view changes to a bar chart.



The marks (which are bars in this case) are vertical because the axis is vertical. The length of each mark represents the sum of the sales for that year. The actual numbers you see here might not match the numbers you see – the sample data changes from time to time.



4. Drag the Ship Mode dimension to Colour on the Marks card.

The view shows how different dispatch modes have contributed to total sales over time. The ratios look consistent from year to year.



5. Drag the Region dimension to Rows, and drop it to the left of Sales to produce multiple axes for sales by region.



6. To view data in the West region only, you can filter out the other regions. To do this, drag the Region dimension again, this time from the Data pane to the Filters shelf.



7. In the Filter [Region] dialog box, clear the Central, East and South tick boxes, and then click OK.

This view gives you insight into your data – for example, how the dispatch mode has changed in the West over the four-year period.

Check your work: Watch steps 1-7 below

Note: In Tableau 2020.2 and later, the Data pane no longer shows Dimensions and Measures as labels. Fields are listed by table or folder.

One Step Further: Add Totals To Stacked Bars

Adding totals to the tops of bars in a chart is sometimes as simple as clicking the Show Mark Labels icon in the toolbar. But when the bars are broken down by colour or size, each individual segment would labelled, rather than the total for the bar. With a few steps, you can add a total label at the top of every bar even when the bars are subdivided, as in the view you just created. In the following procedure you will technically be adding a reference line. But by configuring that "line" in a certain way, you end up with the labels you want.

1. From the Analytics pane, drag a Reference Line into the view and drop it on Cell.

   

2. In the Edit Line, Band, or Box dialog box, set the aggregation for SUM(Sales) to Sum, set Label to Value, and set Line under Formatting to None:

   

   Then click OK to close the Edit Reference Line, Band, or Box dialog box.

Your view now has currency totals at the top of each bar:



You may need to adjust the view to make it look just right. If the bars are too narrow, the numbers will be truncated; to correct this, press Ctrl + Right on the keyboard to make the bars wider. Or if you want to centre the totals over the bars – by default, they are left-aligned. Do the following:

3. Right-click any of the totals on the bar chart and select Format.

4. In the Format window, in the Reference Line Label area, open the Alignment control and select the Centre option for Horizontal alignment:

   

Other resources

Creation of a Grouped Bar Chart(Link opens in a new window) A knowledge base article with embedded videos that describes how to create grouped bar charts, also known as side-by-side bar charts.