Research and Infographics for Athletic Performance, Sport Science, and Health

In this video, we build an interactive shot chart using X-Y shot coordinates from a dataset from a software program used by teams in the National Hockey League (NHL). The dataset includes all goals and shots on goal for all players during the 2015-16 NHL season.

This is an example end product. Created by Adam Virgile.

Dataset Download

Below, you can download the dataset we will be using for building this interactive Shot Chart. I encourage you to download the dataset and follow along!

How to Create an Interactive Shot Chart in Excel.

So, how did it go? I’d love your feedback. Send me an email at to let me know how it went!