How to Make Stacked Bar Charts in Excel
Channel: Ann K. Emery
Date: 19/01/2013

Stacked bar charts are an excellent option for displaying ordinal data and for highlighting part-to-whole relationships, like the percentage of survey respondents who selected strongly agree, agree, disagree, or strongly disagree.

In this tutorial, I demonstrate how to highlight or select your data table and insert a brand new chart from scratch. I walk you through a few of Excel’s chart options, like a 2D Clustered Bar, Stacked Bar, and 100% Stacked Bar. I also teach you about Switch/Row Columns, an excellent strategy for quickly flipping your chart’s categories around if your initial chart comes out looking funny, and how to quickly change your chart’s color scheme.

00:00 How to Make Stacked Bar Charts in Excel
00:20 2D Clustered Bar Chart
00:48 Stacked Bar Chart 
01:18 100% Stacked Bar Chart
01:39 How to Switch Rows and Columns in a Chart
01:48 How to Change Chart Colors 

-----

Most "professional" reports are too long, dense, and jargony. Transform your reports with our complimentary mini course: https://depictdatastudio.teachable.com/p/soar-beyond-the-dusty-shelf-report/