Length 15:37Make Beautiful Excel Charts Like The Economist (file included)
About this video
Leila Gharani rebuilds three Economist-style charts in Excel: a 100% stacked bar chart with linked text boxes, a dumbbell chart built from a scatter plot with error bars, and a color-coded table made from shapes in cells. Each is set up to update automatically when source data changes. The color-coded table requires Microsoft 365.
What you’ll learn
- Build a 100% stacked bar chart with category titles linked to cells
- Create a dumbbell chart from a scatter plot using error bars
- Make a color-coded table that updates automatically with XLOOKUP and UNIQUE










