How to create a Clustered Stacked Column Chart in Excel

👉 What You'll Learn:
In this video tutorial you'll learn how to create a Clustered Stacked Column Chart in Excel. The steps are the same if you want to make a Stacked Bar Chart Excel.

⌚ Timestamps
00:00 Introduction
00:15 Prepare your Data
00:40 Create the Chart
01:00 Modifythe Chart

🎬 LINKS to other videos:

🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍

#excel #excelcharts

[StephanieDavis]

Thank you; I used this concept for work. I was pulling my hair out trying to figure the solution. Thanks again.

[pakorabanne]

Brilliant, I didn't realise it was that easy, thanks so much!!

[amberarnold]

thank you! I got exactly what I was looking for!

[antoniofady]

Thank you sir, i am trying to make a single bar, how to make.. tried but unable..pls help

[theprinceoftigers]

This video looks very helpful for me.
Thank you so much.

[dranreb]

How did you integrate the course 1 and its subsection (income, expense, etc.)?

[CarloPizzutiChannel]

Thanks :). It was very useful the: "switch row/column" ;)

This helped, I got the graph I was looking for! Thanks!

[YamiRa]

i have a question. i'm trying to make a clustered stacked graph. where i have the mass of Soil, Roots, Plants and leaves. i can combine them in a stacked column. But i would like to visualize that the roots and the soil are underground. so iwant them UNDER the X-axis.

I have tried with giving them negative values. and that gives me a visual representation of what i want. but it is not very elegant. to have these negatives values for the mass of my samples.

Any ideas of how i could have an elegant solution? :)
thank you for your time

[TheDoubleAJent]

how do you get the columns within one course to have different color palettes? For example: if you wanted income to use blue hues but expense to use grey hues?

[deepcoolclear]

Good video. How do you change the height of each cell (the diff colors) to show the data values inside them?

[tiffanykoontz]

How do I sort the data if it involves percentages>? So smallest percent is on the bottom of the graph?

[mitchcholewinski]

How can you add additional data after it is already created?

[robocop]

This is a "Stacked" column chart. This is not a "Clustered Stacked" column chart. "Clustered" column charts are where columns are grouped along x axis (think 3 groups of 2 bars close to each other for a total of 6 bars).

[tn]

when i do this on my computer im having an issue, can someone help me? my titles are are going where "income" and "expenses" is on the chart.