Make Beautiful Excel Charts Like The Economist (file included)

Leila Gharani on YouTubeWatch on YouTube

SaveMark complete

Sign in to save videos and track what you’ve finished.

IntermediateData Visualization19 min

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