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?
- Navigate to the Bar Chart (two levels) sheet where you will find an initial view identical to the one you created previously.
- Drag the Region field from Dimensions in the data pane 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 ...
