Table of Contents
100% Stacked Bar Chart
A 100% Stacked Bar Chart is a great way to compare a percentage that each value contributes to its total.
So if we have sales rep sales for three consecutive years, we can plot this on a graph and it will show us what each sales rep´s percentage breakdown is per year.
Download workbook100pc-Stacked.xlsx
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.