Open Excel and select your data that you want to visualize in the McKinsey chart. Go to the ‘Insert’ tab and click on ‘Waterfall’ or ‘Stock chart’ and then select ‘Waterfall’.