WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Column Chart in excel

Column Chart in excel

Column Chart in Excel

Column chart in excel is a chart which is used to represent data in vertical columns, the height of the column represents the value for the specific data series in a chart, the column chart represents the comparison in the form of column from left to right, now if there is a single data series it is very easy to see the comparison.

Types of a Column Chart in Excel

Column Chart Example 1-12

We have a different type of column/bar charts available in MS Excel, and these are:

  1. Clustered Column Chart: A clustered chart in excel presents more than one data series in clustered vertical columns. Each data series shares the same axis labels, so vertical bars are grouped by category. Clustered columns make possible the direct comparison of multiple series and can show change over time, but they become visually complex after adding more series. They work best in situations where data points are limited.
  2. Stacked Column Chart: This type is useful for representing the total (sum) because these visually aggregate all of the categories in a group. The negative point about this is that it becomes difficult to compare the sizes of the individual categories. Stacking enables us to show a part of the whole relationship.
  3. 100% Stacked Column Chart: This is a chart type helpful to show the relative % of multiple data series in stacked columns, where the total (cumulative) of stacked columns always equals 100%.

How to Make Column Chart in Excel? (with Examples)

You can download this Column Chart Excel Template here – Column Chart Excel Template

Example #1

To make a column chart in excel, first, we need to have data in table format. Suppose we have data related to the popularity of the colors.

Column Chart Example 1

  • Now to make the chart, we first need to select the entire data and then press the shortcut key (Alt+F1) to place the default chart type in the same sheet where the data is or F11 to place the chart in a separate new sheet.

Column Chart Example 1-1

  • Or we could use the long method that is to click on Insert tab -> Under Charts group -> Insert Column or Bar Chart.

Column Chart Example 1-2

We have a lot of different types of column charts to select. However, according to the data in the table and nature of the data in the table, we should for the clustered column. For which type of column chart should we go? This you can find below by reading the usefulness of various column charts.

  • The chart in the same sheet by pressing Alt+F1

Column Chart Example 1-3

  • The chart in the separate sheet by pressing F11

Column Chart Example 1-4

  • Here you can see in Excel 2016; we have a ‘+’ sign on the right side of the chart where we have checkboxes to display the different chart elements.

Column Chart Example 1-5

As we can see, by activating, Axes, Axes Titles, Chart Title, Data Labels, Gridlines, Legend trend line, the chart is looking like this.

  • Different type of elements of the chart are as follows:

Elements of Column Chart

We can enlarge the chart area by selecting the outer circle according to our needs. If we right-click on any of the bars, then we have various options related to the formatting of the bar and chart.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • If we want to change the formatting of only one bar, then we need to click two times on the bar and then right-click, and we can change the color of the individual bars according to the colors they represent.

Column Chart Example 1-7

We can also change the formatting from the right panel, which is opened when we select any bar.

  • By default, the chart is created using the entire data selected, but we can change the appearance of the chart by using the ‘Filter’ sign Column Chart Example 1-9on the right side of the chart.

Example 1-8

  • When a chart is selected, two more contextual tabs, ‘Design‘ and ‘Format,’ get opened in the ribbon.

Example 1-10

Example 1-11

We can use the ‘Design’ tab to format the entire chart, the color theme of the chart, chart type, moving chart, changing the data source, the layout of the chart, etc.

In addition, the ‘Format’ tab for formatting individual chart elements like bars, text.

Example #2

Please find below column chart to represent the data of Amazon sales product wise

Example 2

As we can see, the chart has become visually complex to analyze, so we will now use the ‘Stacked Column Chart’ as it will also help us out to find the contribution of the individual product in the overall sale of the month. To do the same, we need to click on the Design tab->’Change Chart Type’ in the ‘Type’ group.

Example 2-1

Finally, your chart will look like this

Example 2-2

Pros

  • Bar or column chart is more popular than another type of complicated chart as it can be understood by a person who is not much more familiar with chart representation but has gone through column charts in magazines or newspapers. Column or bar charts are self-explanatory.
  • It can also be used to see the trend for any product in the market. Make trends easier to highlight than tables do.
  • Display relative numbers/proportions of multiple categories in a stacked column chart.
  • This Chart helps to make a summary of a large amount of data in a visual, easily interpretable manner.
  • This Chart estimates can be made quickly and accurately—permit visual guidance on the accuracy and reasonableness of calculations.
  • Accessible to a wide audience as easy to understand.
  • This Chart is used to represent negative values.
  • Bar charts can hold both data in distinct categories and data of one category in different periods.

Cons

  • It fails to expose key assumptions, causes, impacts, causes. That is why it is easy to manipulate to give incorrect impressions, or we can say they simply do not provide a good overview of the data.
  • The user can make comparisons of arbitrary data segments quickly on a bar chart but are not able to compare two slices that are not neighbors at once.
  • The main disadvantage of bar charts is that it is straightforward to make it unreadable or just wrong.
  • A bar graph can be easily manipulated to give a false impression of a data set,
  • Bar graphs are not useful when trying to display changes in speeds, such as acceleration.
  • Using too many bars in a bar chart looks extremely cluttered.
  • A line graph in excel is more useful when trying to show trends over the course of time.

Things to Remember

  • Both the Bar and the Column chart display data using rectangular bars where the length of the bar is proportional to the data value, but Bar charts are useful when we have long category labels.
  • Use various colors for bars to contrast and highlight data in your chart.
  • Use self-explanatory chart title, axis titles.
  • When the data is related to different categories, then use this chart; otherwise, for another type of data like for representing the continuous type of data, we can use a line chart.
  • Start the graph with zero always as it can mislead and create confusion while comparing.
  • Don’t use extra formatting like the bold font or both types of gridlines in excel for plot area so that the main point can be seen and analyzed clearly.

Recommended Articles

This has been a guide to the Column Chart in Excel. Here we discuss its uses and how to create a Column Chart in Excel along with examples and a downloadable template. You may also look at these useful functions in excel –

  • Column Lock Excel
  • Pareto Chart in Excel
  • Area Chart in Excel
  • Gantt Chart in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Column Chart Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More