A clustered column chart groups multiple date series by category in vertical columns.
Clustered column charts make it easy to spot trends.
Note that the horizontal axis labels come from row 4.
The Select Data window will also confirm the legend and category axis labels.
To change the grouping to quarters, use the switch columns and rows button.
Now data series comes from regions, and columns are clustered by quarter.
Now that we have the grouping we want, I can make several changes to clean up this chart.
First, I’ll add a descriptive title.
Then I’ll remove the space between the columns, and make the columns a bit thicker.
I’ll also use the paintbrush icon to flatten the color scheme to a monochrome option.
Finally, I’ll apply a simple custom number format to abbreviate data to thousands in the vertical axis.
