Column Chart in Excel

A Column Chart is simple a simple chart to create in Excel.  It is a visual representation of data which is one of the most common charts when it comes to reporting.  This article will take you through the steps to create a column chart.

To Create a Column Chart

Highlight the area which you wish included in the chart.

column chart

In the above example the data B1 to D6 is highlighted.


Choose the Insert Menu

Column chart

From the charts section choose a 2D column chart.

Column Chart in Excel

The above chart is produced.  This chart should be seen as a starting point and can be cleaned up and beautified. 

With some manipulation the chart can look as follows.

Column Finish