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.

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:

See also:Same data in a stacked column chart.

Data used to plot this chart

How to make this chart

At this point, you’re able to finalize the chart by setting a title, and adjusting overall chart size, font size, and colors.

Data used to plot this chart

Data used to plot this chart

Data used to plot this chart

Data used to plot this chart

Select clustered column option

Initial clustered column chart as inserted

Switch rows and columns to group by quarter

Switch rows and columns to group by quarter

Move legend to top

Add data labels to chart

Apply custom number format to all data labels

Set series overlap and gap width

Final clustered column chart