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:
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):
(2) Then, go to the Insert tab:
(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):
(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…
(5) Your new chart will now be presented on your worksheet:
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’:
(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’:
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:
(2) This is how your new Column chart would look like:
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:
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