The Magnificent Seven Market Capitalisation

Still using bar charts for everything? Instead, try Lollipop charts - cleaner, lighter, and easier on the eye.

This Week's Chart Drop

Nvidia recently hit $5 trillion in market capitalisation (that’s 12 zeros!). It feels like just yesterday we were marvelling at Apple hitting $1T.

Design Trick

Most Excel users build Lollipop charts using scatter charts and error bars. The problem? If you don’t do it often, it’s easy to forget the steps. Here’s the good news: there’s a simple trick - using just one Excel function you can create both Lollipop and bar charts quickly and reliably.

We run periodic workshops on how to create Lollipop charts. Explore our workshops here

Each week, I share one simple Excel visual—from sport, business, or personal finance—to give finance professionals ideas on how to present their data.

Subscribe to get the weekly chart to your inbox