Quarterly Sales By Clustered Region

This chart shows quarterly sales data, broken down by quarter into four regions plotted with clustered columns.Clustered column charts work best when the number of data series and categories is limited. In order to make the data labels fit into a narrow space, the chart uses a custom number format ([>=1000]#,##0,“K”;0) to show values in thousands.

The data used to plot this chart is shown below:

How to make this chart

1. Select the data and insert a column chart:
2. Select the clustered column option
3. Initial chart:
4. Switch rows and columns to group data by quarter:
5. After switching rows and columns:

1. Move legend to top:
2. Add data labels:
3. Select data labels (one series at a time), and apply the custom number format for thousands:
4. Set series overlap and gap width:
5. Select and delete primary axis
6. Select and delete gridlines
7. Final stacked column chart:

At this point, you can finalize the chart by setting a title, and adjusting overall chart size, font size, and colors.

This chart shows quarterly sales, broken down by quarter into four regions that are stacked, one on top of the other. Stacked column charts can work well when the number of data series and categories is limited. This chart also shows how to use a custom number format ([>=1000]#,##0,“K”;0) to show values in thousands.

The data used to plot this chart is shown below:

How to make this chart

1. Select the data and insert a column chart:
2. Select the stacked column option
3. Initial chart:
4. Switch rows and columns to group data by quarter:
5. After switching rows and columns:
6. Move legend to top:
7. Add data labels:
8. Select data labels, fill white, then apply custom number format for thousands:
9. Select axis and apply same number format:
10. Set series overlap and gap width:
11. Final stacked column chart:

At this point, you can finalize the chart by setting a title, and adjusting the overall chart size and font size for text objects.