EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Excel Clustered Column Chart
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 (36+)
  • 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 (220+)
  • 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

Excel Clustered Column Chart

By Madhuri ThakurMadhuri Thakur

Clustered Column Chart in Excel

Clustered Column Chart (Table of Contents)

  • Clustered Column Chart in Excel
  • How to Make Clustered Column Chart in Excel?

Clustered Column Chart in Excel

Clustered Column Charts are the simplest form of vertical column charts in excel available under the Insert menu tab’s Column Chart section. Clustered columns show the growth of all the selected attributes covers the time period allowed by the chart itself. To create this, we simply have to select the data which have been available over a different time period, and we will have columns for each parameter. This is quite useful when we want to show growth.

Start Your Free Excel Course

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

Steps to Make Clustered Column Chart in Excel

To do that, we need to select the entire source Range, including the Headings.

After that, Go to:

Insert tab on the ribbon > Section Charts > > click on More Column Chart> Insert a Clustered Column Chart

Also, we can use the short key; first of all, we need to select all data and then press the short key (Alt+F1) to create a chart in the same sheet or Press the only F11 to create the chart in a separate new sheet.

Clustered Column Chart Step 1

When we click on more column chart, then we got a new window as below mention. We can choose the format then click on Ok.

Clustered Column Chart Step 2

How to Make Clustered Column Chart in Excel?

Clustered Column Chart in Excel is very simple and easy to use. Let us understand the working of Clustered Column Chart with some examples.

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

Clustered Column Chart in Excel Example #1

There is a summarization of data; this summarization is a company’s performance report, suppose some sales team in different location zone, and they have a target for sale the product. All filed like target, order count, Target, Order Value, Achieved %, Payment received, Discount % is given in the summary; now we can see them in a table as below mention. So we want to display the report by using a cluster column chart.

Clustered Column Chart Example 1-1

First of all, select the range. Click on Insert Ribbon > Click on Column chart > More column chart.

Clustered Column Chart Example 1-2

Choose the clustered column chart > Click on Ok.

Clustered Column Chart Example 1-3

Also, we can use a shortcut key ( alt+F11).

Clustered Column Chart Example 1-4

This visualization is default by excel; if we want to change anything so excel allows us to change the data and anything as we want.

If we see on the right hand, so there is an option ‘ + ’ sign, so with the help of the ‘ + ‘ sign, we can display the different chart elements which are we need.

Clustered Column Chart Example 1-5

When we use the chart and select then two tabs more display. ‘Design ‘and ‘Format ‘as ribbon,

Clustered Column Chart Example 1-6

We can format the chart and color themes layout of the chart with the help of the Design ribbon tab.

Both ribbons are very useful for a chart. E.g., if we change the layout quickly, then just click on the Design tab and click on quick layout and change the layout of the chart.

Clustered Column Chart Example 1-7

If we want to change the color, we can use a shortcut to change the style and color of the chat; just click on the chart, and there is an option highlighted, as shown below.

Clustered Column Chart Example 1-8

Click on the style you want.

Clustered Column Chart Example 1-8(Style)

Chart also is given facility to filter the column which we do not need, similarly just click on the chart, at the right side, we can see the filter sign, as showing below mention pictures.

Clustered Column Chart Example 1-9

Now we can click on a column that we need to show in the chart.

Clustered Column Chart Example 1-10

Again we can change the data range also; Right-click on the chart and select the data option; then, we can change the data also.

Clustered Column Chart Example 1-11

We can change the axis horizontally or vertically by just click on the switch row/column. We can also add or remove and edit a file.

Clustered Column Chart Example 1-12

We can also format the chart area by just right click on the chart and select the format chart area option.

Clustered Column Chart Example 1-13

Then we get a new window on the right side, as shown below.

Clustered Column Chart Example 1-14

Just click on the chart option, then we can all options of formatting the chart like chart title, Axis, legend, plot area, series and vertically.

Clustered Column Chart Example 1-15

Then click on the option which we want to format.

In the Next Tab, we also format the text.

Clustered Column Chart Example 1-16

Some more important things are like add data labels, show trend line in chat; we need to know.

If we want to show data labels as a percentage, just right-click on a column and click on add data labels.

Clustered Column Chart Example 1-17

Data Label is added to the chart.

Clustered Column Chart Example 1-18

Also, we can show data labels with descriptions. With the help of data callouts. Right-click on column data column labels, click on add data labels and click on add data callouts. The picture is showing below mentioned.

Clustered Column Chart Example 1-19

Data Callouts are added to the chart.

Clustered Column Chart Example 1-20

Sometimes we need trend analysis also on a chart. So right-click on data labels and add the trend line.

Clustered Column Chart Example 1-21

A Trendline is added to the chart.

Clustered CC Example 1-22

We can also format the trend line.

Clustered CC Example 1-23

If we want to format the gridlines, then right-click on Gridlines and click on format gridlines.

Clustered CC Example 1-24

Clustered CC Example 1-25

Right Click on Gridlines and click on Add Miner Gridlines.

Clustered CC Example 1-26

A miner Gridlines is added to it.

Clustered CC Example 1-27

Right Click on Gridlines and click on Format Axis.

Clustered CC Example 1-28

Clustered CC Example 1-29

Finally, the Clustered Column Chart looks as given below.

Clustered CC Example 1-30

Pros and Cons of a Clustered Column Chart in Excel

Following are the Pros and Cons:

Pros

  • Since a Clustered Column chart is a default Excel chart type, at least until you set another chart type as a default type
  • It can be understood by any person and will look presentable who is not much more familiar with the chart.
  • It helps us to make a summarization of a huge data in the visualization, so easily we can understand the report.

Cons

  • It’s visually complex when we add more categories or series.
  • At one time more difficult to compare a single series across categories.

Things to be Remember

  • All columns and labels should be filled with various colors to highlight the data in our chart easily.
  • Use self-explanatory chart titles, axes titles. So by the title name, one can understand the report.
  • If the data is relevant for this chart, then use this chart; otherwise, the data is related to different categories; we can choose another chart type that is representable.
  • No need of using extra formatting so that anyone can see and analyze all points clearly.

Recommended Articles

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

  1. Comparison Chart in Excel
  2. Pie Chart In MS Excel
  3. Excel Stacked Column Chart
  4. Excel Column Chart
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
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

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

EDUCBA
Free Excel Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

Let’s Get Started

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
EDUCBA

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

Download Clustered Column Chart Excel Template

EDUCBA Login

Forgot Password?

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

EDUCBA

Download Clustered Column Chart Excel Template

EDUCBA

डाउनलोड Clustered 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