Right now, you are looking at the overall sales over time. Let's do some analysis at a slightly deeper level:
- Navigate to the Sales over time (overlapping lines) sheet, where you will find a view identical to the one you just created.
- Drag the Region field from Dimensions to Color. Now you have a line per region, with each line a different color, and a legend indicating which color is used for which region. As with the bars, adding a dimension to color splits the marks. However, unlike the bars, where the segments were stacked, the lines are not stacked. Instead, the lines are drawn at the exact value for the sum of sales for each region and quarter. This allows for easy and accurate comparison. ...