Bar Charts Exercise 3

Consider an alternate view, using the same fields arranged differently:

1. Navigate to the Bar Chart (stacked) sheet, where you will find a view that is identical to the original bar chart.

2. Drag the Region field from the Rows shelf and drop it onto the Color shelf:

Figure 1.13: The Bar Chart (stacked) view should look like this

Instead of a side-by-side bar chart, you now have a stacked bar chart. 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.