PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

CREATE COLUMN CHART IN EXCEL

INTRODUCTION

CHARTS are the graphic representation of any data . As we know that EXCEL is a super analytical tool.

Analysis of data is the process of deriving the inferences by finding out the trends, averages etc. about different parameters.

Data is everywhere. There is no work, where we don’t deal with the data. Sales data in business, employee data, patient data in hospitals, students data in school etc. Maximum data is presented in the tables but we all know that visual representation is easier to interpret. That is the reason that as the Excel developed, so the charts options in Excel.

Excel gives us a variety of charts which are beautiful, colorful, more customizable and more powerful.

In this article we are going to discuss one particular type of the charts which are known as COLUMN CHART.

In column charts, the data is represented by the tall columns which represent the data with their heights.

WHEN TO USE COLUMN CHARTS

Charts are a visual representation of the data. Although nobody can give a fixed answer for this question about the usage of any specific chart at some special situation, but even then , we can list out a few situation when it is apt to use COLUMN CHARTS.

Here is the list of situations when we should use COLUMN CHARTS.

  • When there is quantity comparison between a few categories such as sales comparison. Which year had bigger sales number and which has smaller etc. in a particular year.
  • We need to visualize the numbers of values of different products for different years.

BUTTON LOCATION FOR INSERTING COLUMN CHARTS

The button for column chart is found under the INSERT TAB under the CHARTS SECTION.

CREATE CLUSTERED COLUMN CHART IN EXCEL
EXCEL:BUTTON LOCATION FOR INSERTING COLUMN CHARTS

STEPS TO INSERT A COLUMN CHART IN EXCEL

EXAMPLE DETAILS

We can demonstrate a chart by the use of an example.
So first of all we’ll take a simple chart.
The following data is of company ABC for the sales of 5 years.
YEARSALES(MILLION)
2016-17235
2017-18452
2018-19786
2019-201230
2020-20211500

The procedure to insert a column chart are as follows:

STEPS TO INSERT A COLUMN CHART IN EXCEL:

  • The first requirement of any chart is data. So create a table containing the data.
  • Refer to our data above, we have sales figures for five years.
  • In this example we have a simple representation of sales. Comparison is between the years only.
  • Select the complete table including the HEADER NAMES.
  • Go to INSERT TAB> CHARTS> and click the 2D COLUMN button as shown in the BUTTON LOCATION above.
  • The chart will be created and shown to you as the following figure.
 
 The complete process is shown in the animated picture below.
CREATE COLUMN CHART IN EXCEL
EXCEL:STEPS TO USE CLUSTERED COLUMN CHART

So , we have successfully inserted the chart. We can see that we have inserted a 2-D column chart.

The chart shows the sales of different years .

Now we can see that inferences from the chart are easier to interpret than the table. This is the benefit of the charts or graphs.

Now, after we have already created a chart , let us check the different types of column charts available.

TYPES OF COLUMN CHARTS IN EXCEL

There are a few types of column charts. They are as follows.

    • CLUSTERED COLUMN
    • STACKED COLUMN
    • 100% STACKED COLUMN
    For these charts we need more than one category so that we can understand its usage. So let us now elaborate our same table and take the sales of two products for the same years.
  • So the table becomes
  • SALES DATA 
    YEARCARSBIKES
    2016-17235150
    2017-18452300
    2018-19786400
    2019-201230600
    2020-20211500800
 
 
 

We’ll check how to create and use these charts for the above table.

 

CLUSTERED COLUMN CHART IN EXCEL

Clustered column chart is simply the column chart which we discussed. The clustered word is used as when we have more than one category, the columns are clustered for each year. Let us create the clustered chart. The process is same as we discussed earlier.

 

STEPS TO CREATE CLUSTERED COLUMN CHART IN EXCEL

The procedure to insert a column chart are as follows:

STEPS TO INSERT A CLUSTERED COLUMN CHART IN EXCEL:

  • The first requirement of any chart is data. So create a table containing the data.
  • Refer to our data above, we have sales figures of two categories CARS and BIKES for five years.
  • In this example we have a simple representation of sales. Comparison is between the years only.
  • Select the complete table including the HEADER NAMES.
  • Go to INSERT TAB> CHARTS> and click the 2D CLUSTERED COLUMN button as shown in the BUTTON LOCATION 
  • The chart will be created and shown to you as the following figure.
 
 The output is shown below.
 
CLUSTERED COLUMN CHART IN EXCEL
EXCEL: CLUSTERED COLUMN CHART IN EXCEL

We use CLUSTERED COLUMN CHART when we need to perform a simple comparison. In this chart, we can get the clear indication if bikes are sold more or cars in any particular year.

 

STEPS TO CREATE 3D CLUSTERED COLUMN CHART IN EXCEL

The same chart can be created in 3D also. There is no difference in both except the looks.

STEPS TO INSERT A CLUSTERED COLUMN CHART IN EXCEL:

  • The first requirement of any chart is data. So create a table containing the data.
  • Refer to our data above, we have sales figures of two categories CARS and BIKES for five years.
  • In this example we have a simple representation of sales. Comparison is between the years only.
  • Select the complete table including the HEADER NAMES.
  • Go to INSERT TAB> CHARTS> and click under the 3D CLUSTERED COLUMN button as shown in the BUTTON LOCATION 
  • The chart will be created and shown to you as the following figure.
 
 The output is shown below.
 
3D CLUSTERED COLUMN IN EXCEL
EXCEL:3D CLUSTERED COLUMN CHART IN EXCEL

We use 3D CLUSTERED COLUMN CHART when we need to perform a simple
comparison. In this chart, we can get the clear indication if bikes are
sold more or cars in any particular year.

 

stacked COLUMN CHART IN EXCEL

Other type of the COLUMN CHARTS is the STACKED COLUMN CHART.

The STACKED COLUMN CHART shows the data one stacked on the other.

WHEN TO USE STACKED COLUMN CHART:

We can use this type of chart when we need to show one data as a part of other. Something like A is this much portion of TOTAL.

STEPS TO CREATE STACKED COLUMN CHART IN EXCEL

The procedure to insert a column chart are as follows:

STEPS TO INSERT A STACKED COLUMN CHART IN EXCEL:

  • The first requirement of any chart is data. So create a table containing the data.
  • Refer to our data above, we have sales figures of two categories CARS and BIKES for five years.
  • In this example we have a simple representation of sales. Comparison is between the years only.
  • Select the complete table including the HEADER NAMES.
  • Go to INSERT TAB> CHARTS> and click the 2D STACKED COLUMN button as shown in the BUTTON LOCATION .
  • The chart will be created and shown to you as the following figure.
 
 The output is shown below.
 
CREATE STACKED COLUMN CHART IN EXCEL
EXCEL: STACKED COLUMN CHART IN EXCEL

We use STACKED COLUMN CHART when we need to show the portion of any category with respect to the total. In the chart we can see that each category shown with a color, represent a portion of the total. The total value can be found , so the other two values of the portions.

 

3D stacked COLUMN CHART IN EXCEL

The STACKED COLUMN CHART  can be made in 3D also.There is no difference in 3D chart from the 2D chart except the look and feel.

WHEN TO USE 3D STACKED COLUMN CHART:

We can use this type of chart when we need to show one data as a part of other. Something like A is this much portion of TOTAL.

STEPS TO 3D CREATE STACKED COLUMN CHART IN EXCEL

The procedure to insert a column chart are as follows:

STEPS TO INSERT A 3D STACKED COLUMN CHART IN EXCEL:

  • The first requirement of any chart is data. So create a table containing the data.
  • Refer to our data above, we have sales figures of two categories CARS and BIKES for five years.
  • In this example we have a simple representation of sales. Comparison is between the years only.
  • Select the complete table including the HEADER NAMES.
  • Go to INSERT TAB> CHARTS> and click the 3D STACKED COLUMN button as shown in the BUTTON LOCATION .
  • The chart will be created and shown to you as the following figure.
 
 The output is shown below.
 
3D STACKED COLUMN CHART IN EXCEL
EXCEL: 3D STACKED COLUMN CHART IN EXCEL

We use 3D STACKED COLUMN CHART when we need to show the portion of any category with respect to the total. In the chart we can see that each category shown with a color, represent a portion of the total. The total value can be found , so the other two values of the portions.

 

100% stacked COLUMN CHART IN EXCEL

Other type of the COLUMN CHARTS is the 100% STACKED COLUMN CHART.

The STACKED COLUMN CHART shows the data one stacked on the other.

WHEN TO USE 100% STACKED COLUMN CHART:

In simple stacked column charts we have the values, whereas in 100% STACKED COLUMN CHARTS we have the percentages. It shows the percentage of each category.

STEPS TO CREATE 100% STACKED COLUMN CHART IN EXCEL

The procedure to insert a column chart are as follows:

STEPS TO INSERT 100% STACKED COLUMN CHART IN EXCEL:

  • The first requirement of any chart is data. So create a table containing the data.
  • Refer to our data above, we have sales figures of two categories CARS and BIKES for five years.
  • In this example we have a simple representation of sales. Comparison is between the years only.
  • Select the complete table including the HEADER NAMES.
  • Go to INSERT TAB> CHARTS> and click the 2D 100% STACKED COLUMN button as shown in the BUTTON LOCATION . 
  • The chart will be created and shown to you as the following figure.
 
 The output is shown below.
 
100% STACKED COLUMN CHART
EXCEL: 100% STACKED COLUMN CHART IN EXCEL

We use 100% STACKED COLUMN in the situations where we need to show the percentage participation of any number of categories say 2 ,3 4 and so on.

In our example, we have two categories , so for any year we can find easily the data like how many bikes were sold for the total number of vehicles sold for any particular year.

This is a it better than simple STACKED COLUM CHART as it shows the result in %.

 

3D 100% stacked COLUMN CHART IN EXCEL

Other type of the COLUMN CHARTS is the 100% STACKED COLUMN CHART.

The 100% STACKED COLUMN CHART can also be made in 3D. There is no difference in 3D chart from the 2D chart except the look and feel.

WHEN TO USE 100% STACKED COLUMN CHART:

In simple stacked column charts we have the values, whereas in 100% STACKED COLUMN CHARTS we have the percentages. It shows the percentage of each category.

STEPS TO CREATE 100% STACKED COLUMN CHART IN EXCEL

The procedure to insert a column chart are as follows:

STEPS TO INSERT 100% STACKED COLUMN CHART IN EXCEL:

  • The first requirement of any chart is data. So create a table containing the data.
  • Refer to our data above, we have sales figures of two categories CARS and BIKES for five years.
  • In this example we have a simple representation of sales. Comparison is between the years only.
  • Select the complete table including the HEADER NAMES.
  • Go to INSERT TAB> CHARTS> and click the 2D 100% STACKED COLUMN button as shown in the BUTTON LOCATION . 
  • The chart will be created and shown to you as the following figure.
 
 The output is shown below.
 
3D 100% STACKED COLUMN CHART
EXCEL: 3D 100% STACKED COLUMN CHART IN EXCEL

We use 100% STACKED COLUMN in the situations where we need to show the percentage participation of any number of categories say 2 ,3 4 and so on.

In our example, we have two categories , so for any year we can find easily the data like how many bikes were sold for the total number of vehicles sold for any particular year.

This is a it better than simple STACKED COLUM CHART as it shows the result in %.

 

NOTE:

FOR ALL OTHER TASKS LIKE CHANGING THE NAME OF THE CHART, CHANGING THE AXIS , CHANGING THE CHART STYLE ETC. VISIT HERE [HOW TO CREATE A CHART IN EXCEL].

 

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: