How to Create a Column Chart in MS Excel 2010

Need to create a Column Chart in MS Excel? There is an easy way to do it in Excel. In this post, I’ll show you how to create a Column chart in MS Excel 2010.

But before we begin, you’ll need a data-set that will be presented in your Column Chart.

I created the following data-set that contains a simple table with information about:

• The total number of tasks that needs to be performed (perhaps as part of a project or business you are currently working on)
• The number of ongoing tasks
• The number of tasks completed

The tasks are tracked across two years (i.e., 2016 and 2017), as you can see below:

20162017
Total Tasks550700
Ongoing Tasks250300
Tasks Completed300400

Steps to Create a Column Chart in MS Excel

Here, we are going to cover the steps to create your desired Column chart in Excel:

(1) First, copy the above table into MS Excel (or alternatively, type the data into your spreadsheet):

 

Copy a table into MS Excel

 

(2) Then, go to the Insert tab:

 

Insert tab in MS Excel

 

(3) Select all the cells you want to include in your Column chart. Here, we selected the entire table (i.e., the range of cells B3:D6):

 

Select all the cells to be included in your Column Chart in MS Excel

 

(4) Press the ‘Column’ Icon, and then select the ‘3-D Column’ option.

Please note that there are many charts options that you can choose from. I personally like to use the 3D column charts, but feel free to choose other options, such as 2-D Column, Cylinder, Cone, etc…

 

3D Column charts in MS Excel

 

(5) Your new chart will now be presented on your worksheet:

 

Create a Column Chart in MS Excel

Adding a title to your Column chart

(1) If you would like to add a title to your chart, then select the first icon under the Chart Layouts box.

You will now see a default title assigned to your chart. The default title that will appear is ‘Chart Title’: 

 

Chart Title for Column Charts in MS Excel

 

(2) To change the title name of your chart, press the default title name, and then replace it with the name that you desire.

In this example, I changed the name of the title to ‘Task Status’:

 

Change the title name of the Column Chart

Changing the color scheme of your Column chart

(1) If you would like to change the color scheme of your chart, simply choose your desired color from the Chart Styles box under the Design tab.

In our example, I chose to change the color of the Column chart to green, but feel free to choose other colors:

 

Change the color of a Column chart in MS Excel 2010

 

(2) This is how your new Column chart would look like:

 

Change the color of a Column chart to green in MS Excel 2010

Changing the layout of your Column Chart

If you’d like to change the layout of your Column chart, there is a selection of chart layouts that you can choose from under the Chart Layouts tab. Feel free to examine each layout to determine if it is suitable to your needs.

(1) In our case, I chose a layout that will enable me to insert a name for the Y-Axis. Here, I typed the name ‘Number of Tasks’ to represent the Y-Axis of the Column chart:

 

Layouts for Column charts in MS Excel 2010

 

There are different types of charts that you can create in Excel.

In this post, we saw how to create a Column chart in Excel, but feel free to check other chart types, such as Pie Chart