Author: Oscar Cronquist Article last updated on September 30, 2018

The clustered column chart allows you to graph data in vertical bars, this layout makes it easy to compare values across categories.

Use this chart type when order of categories is not important. The categories are displayed on the x-axis.


  1. Select the data you want to graph.
  2. Go to tab "Insert" on the ribbon.
  3. Click on the column chart button.
  4. Click on "Clustered" column chart button.

The chart is now visible on your worksheet. Click and hold with left mouse to drag the chart to the desired location.

Tip! If you want to switch series and categories follow these steps.

  1. Right click on the chart.
  2. Click on "Select Data...".
  3. Click on "Switch Row/Column" button