Making a Scatter Plot in MS Excel using NBA Data | Data Visualization

In this tutorial, you'll learn how to create an impressive 2-dimensional scatter plot using data from the National Basketball Association (NBA) 2022 regular season. Using Microsoft Excel, we'll take you through each step of the process, from inserting the data to formatting the labels and axes for optimal clarity and impact.

One of the key features we'll cover is how to insert the median of a data set as a line in your scatter plot, providing an instant visual reference point for your audience. We'll also explore various formatting options for labels and axes, helping you create a professional and engaging data visualization that effectively communicates your insights.

Whether you're a data analyst, researcher, or just curious about data visualization, this tutorial will equip you with valuable skills and techniques for creating compelling scatter plots that captivate your audience.

Working with Data Table in MS Excel: NBA Stats, Top 10 Filter, and Patterns

00:00 Introduction
00:22 Elements and Goal of the Data Visualization
00:46 Create Chart in Microsoft Excel
01:55 Formatting Chart's Elements in Microsoft Excel
03:10 Excel Built-in Median Function
04:17 Insert Median as a Line Divider
06:45 Add Data Labels to Scatter Plot
07:10 Create Invisible Data Labels
08:05 Format and Style Data Labels
08:42 How to Use Data Visualization to Select NBA Players