Column Chart in Microsoft Excel 2010

In this article, we will learn how and where we can create Column Chart in Microsoft Excel 2010. Column Chart is used to compare the values graphically across a few categories when the chart shows duration or the category text is long.

Column Chart contains 6 types of Column charts including Clustered Column, Stacked Column, 100% stacked Column, 3-D Clustered Column, 3-D Stacked Column, and 3-D 100% stacked Column.

Let’s take an example and understand how we can use the Column chart in Excel.

We have month wise achievement data in which column A contains Month Name and column B contains Achievement.
 
img1
 
Let’s see how this can be achieved.  To create the Column chart, follow below mentioned steps:-

  • Select the data range A1:B13.
  • Go to “Insert” menu on the ribbon, and then click on “Clustered Column” in the “Charts” group.

 
img2
 

  • After inserting the Clustered Column in Excel format 2, contextual tabs will get active where you can format and design the chart to make it presentable.

 
img3
 

  • Go to the Design contextual tab, and choose any chart from the Chart Styles group.

 
img4
 

  • Click on Add Chart Element, and a dropdown list will appear.
  • From the dropdown menu, click on Data Labels.
  • After clicking on Data labels, again dropdown will get appear.
  • Click on Center.

 
img5
 
img6
 

  • To add the chart title, double click on the title.
  • Rename the text as per the requirement, or you can delete it as well.

 
img7
 
This is the way we can create the column chart in Microsoft Excel.
 
 

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.