How to Create Small Multiples Bar Charts in Excel
Channel: Ann K. Emery
Date: 11/06/2013

How to Create Small Multiples Bar Charts in Excel

Blog Posts:

Dataviz Challenge #3: Can You Make a Side by Side Bar Chart? https://depictdatastudio.com/side-by-side-challenge/

How to Make a Side by Side Bar Chart in Excel: https://depictdatastudio.com/how-to-make-a-side-by-side-bar-chart-in-excel/

00:00 How to Create Small Multiples Bar Charts in Excel
00:22 Step 1: Study the Chart That You’re Trying to Reproduce in Excel
00:42 Step 2: Make Two Separate Bar Charts
00:51 Step 3: Type the Data into Excel
00:58 Step 4: Create the First Bar Chart
02:40 Step 5: Copy the First Chart
02:48 Step 6: Populate the Second Chart with Coalition B’s Data
03:15 Step 7: Adjust the Second Chart’s Bar Color and Title
03:39 Step 8: Delete the Second Chart’s Axis Labels
03:54 Step 9: Re-Size the Second Chart
04:40 Step 10: Paste the Charts into PowerPoint or Word

-----

Most "professional" reports are too long, dense, and jargony. Transform your reports with my course. You'll never look at reports the same way again. https://depictdatastudio.teachable.com/p/soar-beyond-the-dusty-shelf-report