EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Column Chart in Excel
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Column Chart in Excel

By Jeevan A YJeevan A Y

Column Chart in Excel

Column Chart in Excel ( Table of Contents )

  • Column Chart in Excel
  • Types of Column Chart in Excel
  • How to Make Column Chart in Excel?

Column Chart in Excel

A column Chart in Excel is the simplest form of a chart that can be easily created if one list of the parameter is against one set of value. Column Chart can be accessed from the Insert menu tab from the Charts section, which has different types of Column Charts such as Clustered Chart, Stacked Column, 100% Stacked Column in 2D and 3D as well. This simply compares the values across different categories with the help of vertical columns.

“The Simpler the chart, the better it is”. Excel Column chart straight forward tells the story of a single variable and does not create any sort of confusion in terms of understanding.

In this article, we will look into the ways of creating COLUMN CHARTS in excel.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Types of Column Chart in Excel

There are totally 5 types of column charts available in excel. Go to the Insert tab and click on the COLUMN.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,768 ratings)

Column chart types

  • 2-D column and 2-D stacked column chart
  • 3-D column and 3-d stacked column chart
  • Cylinder column chart
  • Cone column chart
  • Pyramid column chart

How to Make Column Chart in Excel?

The column Chart is very simple to use. Let us now see how to make a Column Chart in Excel with the help of some examples.

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

Example #1

I have sales data from Jan to Dec. I need to present the data in a graphical way instead of just a table.

I am creating a COLUMN CHART for my presentation. Follow the below steps to get insight.

Step 1: Set up the data first.

Column chart Examples 1-1

Step 2: Select the data from A1 to B13.

Column chart Examples 1-2

Step 3: Go to Insert and click on Column and select the first chart.

Column chart Examples 1-3

Note: The shortcut key to create a chart is F11. This will create the chart all together in a new sheet.

Step 3: Once you click on that chart, it will insert the below chart automatically.

Column chart Examples 1-4

Step 4: This looks like an ordinary chart. We need to make some modification to make the chart look beautiful.

Right click on the bar and select Format Data Series.

Column chart Examples 1-5

Step 5: Go to Fill and select Vary colors by point.

Column chart Examples 1-6

Step 6: Now your chart looks like this. Each bar colored with a different color to represent the different month.

Column chart Examples 1-7

Step 7: Remove Legend by selecting them and pressing the delete key option.

Column chart Examples 1-8

the Legend will be deleted

Column chart Examples 1-9

Step 8: Rename your chart heading by clicking on the titleColumn chart Examples 1-10

select the Gridlines and click on Format Gridlines.

Column chart Examples 1-11

Click on Line Color and select the no line option

Column chart Examples 1-12

Gridlines will be removed.

Column chart Examples 1-13

Step 9: Click on Format Chart Area.

Column chart Examples 1-14

Select Fill option. Under Fill, Select Solid fill and select the background color according to your wish.

Column chart Examples 1-15

Finally, my chart looks like this.

Column chart Examples 1-16

Example #2

In this example, I am going to create a user-defined chart, i.e. based on the clicks you make, it will start to show the results in the column chart.

I am taking the same data from the previous example.

Column chart Examples 2-1

Step 1: Insert a “Horizontal Scroll Bar”. Go to developer tab > Click on Insert and select ScrollBar.

Column chart Examples 2-2

Step 2: Draw the scroll bar in your worksheet.

Column chart Examples 2-3

Step 3: Now right-click on the Scrollbar and select Format Control.

Column chart Examples 2-4

Step 4: Now go to Control and make the changes as shown in the below image.

Column chart Examples 2-5

Current Value: This is the present value now. I have mentioned zero.

Minimum Value: This is the bare minimum value.

Maximum Value: This is the highest value to mention. I have chosen 12 because I have only 12 months of data to present.

Incremental Change: This is once you click on the ScrollBar, what is the incremental value you need to give.

Cell link: This is the link given to a cell. I have given a link to cell C1. If I click on the scroll bar once in cell C1 the value will be 1; if I click on the scroll bar twice, it will show the value as 2 because it is incremented by 1.

Now you can check by clicking on the scroll bar.

Column chart Examples 2-6

Step 5: Now, we need to rearrange the data to create a chart. I am applying the IF formula to rearrange the data.

In cell E5, I have mentioned the formula: If the cell C1 (scrollbar linked cell) is greater than or equal to 1, I want the value from cell B2 (that contains Jan month sales).

Column chart Examples 2-7

Similarly, in cell F5, I have mentioned if cell C1 (scrollbar linked cell) is greater than or equal to 2, I want the value from cell B3 (that contains Feb month sales).

Column chart Examples 2-8

So like this, I have mentioned the formula for all the 12 months.

Column chart Examples 2-9

Step 6: Now insert a COLUMN CHART as shown in example 1. But here, select the rearranged data instead of the original data.

Column chart Examples 2-10

Step 7: Now, the COLUMN CHART has created. The clicks you make on the scroll bar will start to show the bars in the column chart.

As of now, I have clicked the scroll bar only 3 times, so it is showing only for 3 months. If you want to see for the remaining months, you can click the scroll bar up to 12 times.

Column chart Examples 2-11

Advantages of Excel Column Chart

  • Easy to make and understand.
  • Show differences easily.
  • Each bar represents only one series only.

Things to Remember in Dynamic Chart

  • Arrange the data before creating a Column Chart in Excel.
  • Use the Scroll Bar option to make the chart look attractive.
  • If the single series has many data, then it becomes Clustered Chart.
  • You can try many other column charts like a cylinder, pyramid, 3-D charts etc.…

Recommended Articles

This has been a guide to Excel Column Chart. Here we discuss how to create a Column Chart in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. VBA Excel Charts
  2. Excel Clustered Column Chart
  3. Excel Stacked Column Chart
  4. Grouping Columns in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formulas, charts, formatting creating excel dashboard & others

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Column Chart Excel Template

EDUCBA

Download Column Chart Excel Template

EDUCBA

डाउनलोड Column Chart Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more