Summary

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:

Data used to plot this chart

See also: Same data in a stacked column chart.

How to make this chart

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

Switch rows and columns to group by quarter

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

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

 

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.