Creating McKinsey Charts in Excel Quick Guide : 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 ...