Does Your Creating Bar Charts In Tableau Pass The Test?

Bar charts visually represent data in a way that makes comparisons of value across different categories easy. The length of the bar is the primary means by which you will visually understand the data. You may also incorporate color, size, stacking, and order to communicate additional attributes and values.

Creating bar charts in Tableau is quite easy. Simply drag and drop the measure you want to see on either the Rows or Columns shelf and the dimension that defines the categories onto the opposing Rows or Columns shelf.

As an analyst for the Superstore, you are ready to begin a discovery process focused on sales (especially the dollar value of sales). As you follow the examples, work your way through the sheets in the Chapter 01 Starter.twbx workbook. The Chapter 01 Complete.twbx workbook will contain the complete example, so you can compare your results at any time:

1. Navigate to the Sales by Department sheet (view).
2. Drag and drop the Sales field from Measures in the data plane to the Columns shelf. You now have a bar chart with a single bar representing the sum of sales for all the data in the data source.
3. Drag and drop the Department field from Dimensions in the data plane to the Rows shelf. This slices the data to give you three bars, representing the sum of sales for each department:

You now have a horizontal bar chart. This makes the comparison of sales between the departments easy. Notice how the mark type in the drop-down menu on the Marks card is set to Automatic and shows an indication that Tableau has determined that bars are the best visualization given the fields you have placed in the view. 

As a discrete dimension, the Department field defines row headers for each department in the data. As a continuous measure, the Sales field is defining an axis with the length of the bar extending from 0 to the value of the sum of sales for each department. tableau online training 

Iterations of bar charts for deeper analysis

Using the preceding bar chart, you can easily see that the Technology department has more total sales than either Furniture or Office Supplies, which has fewer total sales compared to any other department. What if you want to further understand sales amounts for departments across various regions?

1. Navigate to the Bar Chart (two levels) sheet where you will find an initial view identical to the one you created previously.
2. Drag the Region field from Dimensions in the data plane to the Rows shelf and drop it to the left of the Department field already in the view, as shown:
   

You still have a horizontal bar chart. But now you've introduced Region as another dimension that changes the level of detail in the view and further slices the aggregate of the sum of Sales. By placing Region before Department, you will be able to easily compare sales for each department within a given region.

Now you are starting to make some discoveries. For example, the Technology department has the most sales in every region, except in the East where Furniture has higher sales. Office Supplies never has the highest sales in any region.

Let's take a look at a different view, using the same fields arranged differently:

1. Navigate to the Bar Chart (stacked) sheet where you will find an initial view identical to the one you created previously.
2. Drag the Region field from the Rows shelf and drop it on the Color shelf:
   

Instead of a side-by-side bar chart, you now have a stacked bar chart. Notice how each segment of the bar is color-coded by the Region field. Additionally, a color legend has been added to the workspace. You haven't changed the level of detail in the view, so sales are still summed for every combination of region and department. Learn more Tableau Certification 

Stacked bars are useful when you want to understand part-to-whole relationships. It is now fairly easy to see what portion of the total sales of each department is made in each region. However, it is very difficult to compare sales for most of the regions across departments. For example, can you easily tell which department had the highest sales in the East region? It is difficult because, except for the West, every segment of the bar has a different starting place.

Now, take some time to experiment with the bar chart to see what variations you can create:

1. Navigate to the Bar Chart (experimentation) sheet.
2. Try dragging the Region field from Color to the other shelves on the Marks card, such as Size, Label, and Detail. Observe that in each case, the bars remain stacked but are redrawn based on the visual encoding defined by the Region field.
3. Use the Swap button on the toolbar to swap fields on Rows and Columns. This allows you to very easily change from a horizontal bar chart to a vertical bar chart (and vice versa):
4. Drag and drop Sales from the Measures section of the data pane on top of the Region field on the Marks card to replace it. Drag the Sales field to Color if necessary and notice how the color legend is a gradient for the continuous field.
5. A further experiment by dragging and dropping other fields onto various shelves. Note the behavior of Tableau for each action you take.
6. From the File menu, select Save.