Clustered Column Charts

Learning Objectives

  • Create a clustered column chart.

Excel is not just used for organizing and processing data and formulas. It also can be used to visually represent data in the form of charts and graphs. In this page, we will work on creating a basic chart, the clustered column chart, and then modifying a chart style.

A clustered column chart is sometimes called a bar graph, because it shows data organized in solid shapes like pillars. A clustered column chart organizes these pillars up and down, so they are “columns.” On the other hand, a clustered bar graph organizes these pillars left to right, so they are “bars.” Bar graphs are useful charts when looking at changes from month to month or across employees.

The first step to creating any chart is to organize your data. It is definitely a good idea to include headers in the first cell of each column. By default, a clustered column chart will cluster the data by the columns in your table, so try to keep that in mind when setting up the worksheet.

  1. After organizing your data, select the cells you wish to include in the chart. This should be at least two columns.
  2. Click on the Insert tab and find the Charts group of the ribbon.
An excel sheet with data entered in columns A and B through row 13. There is a green box highlighting where to find the recommended charts option.
  1. “Clustered column chart” is actually a recommended chart. Click on that chart.
An insert chart dialog box is open, with clustered column chart selected.
  1. When you select the chart, you will see colored boxes surrounding the data that connect to the different categories of the chart.
An excel sheet with data entered in columns A and B through row 13. To the right of column B there is a clustered graph open representing the data in cells A1 through B13.

Practice Question

Practice Question