How To... Create a Stacked Chart in Excel 2010

In this video you will learn how to create a stacked column chart to visualize data in a table. Stacked charts are useful when you want to display more than one set of data.

[weakataglance]

Thank you so much Irish guy! Very useful stuff! I finished my assignment very quickly with your help.

[Pkw]

You are very nice presenter sir. I'm relieved now. Pes, from Papua New Guinea

[AlejandroCastroDelgado]

Very nice. I was doing it on my data as you went through the tutorial. Very easy. Thank you.

[DanielMooreClan]

Thanks for this... just to note - in Excel 2010, it will select the X axis automatically. So you will get a completely different result if you select up to the column March in your example from if you selected up to April. 

[EugeneOLoughlin]

Hi mastahswordz,

Not sure why you would want to do this for this chart, but the simplest way would be to change the titles of the months to include the date, ie: change "January" to "1st January".

Dr E.

[EugeneOLoughlin]

Hi uugn,

Try putting percentage values in your cells (make sure they are formatted as "percentage").

Dr E.

[mastahswordz]

Hi Dr E,

thanks I appreciate your reply. sorry i was looking for a way on how to create a gantt chart using stacked horizontal bar. And force the x-axis to return 1st day of the month

[nohanhan]

Hi Dr. E,

I was trying to follow our instruction to create the bar chart that I desire. However, the end result is not what I wanted.
I wanted to have 2 bar chart lay out, with the first one called the Project Run Time and it spans from month 0 - month 12 (this is the easy part) and the second bar called Project Breakdown where I listed out the different stage, Start, Planning, Executing, Monitoring and Closing.

[dnonly]

How to create a graph when you eant to show same chart but comparing year on year requirement of various resources.

[mastahswordz]

how do you force x-axis to use 1st day of the month when you use a stacked horizontal bar?

[EugeneOLoughlin]

HI mastahswordz,

Please check other videos in my channel on how to create and edit Gantt charts in Excel, plus some on using Resource Histograms (like stacked charts).

Good luck with your studies,

Dr E.

[nohanhan]

I will have different month span for different stage, and want them to end up stacking up on each other which total equals 12 months (equivalent to the first bar)
This has given me immense amount of trouble, would you be possible to identify how I could achieve such task?

Regards,
Dr. E

[KhIoMng]

Hi! How can I create the cylinder chart similar to that for a revenue goal that is divided into each month and show the progress of each month?

[dietervanderwillik]

How do I construct a chart that has 3 data sets in one bar chart, but lets say that the data set is as follow 100%blue, 74%red and 17% black how do I get the bar to show on the axis a max value of 100% with the 74% and 17% showing in the bar chart and not give me a total of 191% like a normal stacked chart??

[uugn]

How to show percentage numbers in this chart?

[alastairleith]

that graph is unreasonably ugly/ next video please…