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. Press with mouse on the column chart button.
  4. Press with mouse on "Clustered" column chart button.

The chart is now visible on your worksheet. Press 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. Press with right mouse button on on the chart.
  2. Press with mouse on "Select Data...".
  3. Press with mouse on "Switch Row/Column" button