To make McKinsey charts interactive, integrate dynamic Excel formulas that update the chart in real-time as the underlying data changes, transforming static visuals into interactive tools.

In this guide, I'll walk you through the different ways to format your chart, with Excel's main chart-formatting actions written in bold so you can find them more easily.

This guide shows how to create progress bars in Excel using Bar Charts and Conditional Formatting on a Windows 11/10 PC. Take a look.