How to create a scatter plot
Creating Scatter Plots in Excel
In this video, we will learn how to create a scatter plot to depict the interplay between two variables with one dataset including cleaning up axes and formatting, adding a trendline with its equation and R square value. From there, we also explore how to build a more advanced scatter plot that compares two datasets (female and male) with distinct colors, marker shapes, and associated legend.
Chapters:
0:00 Introduction
0:33 Selecting and copying the data
1:28 Removing non-responders (filtering out 99 values)
2:27 Choosing the scatter plot
3:17 Cleaning up the axes
4:51 Adding a linear trendline
5:57 Displaying the equation & R square
6:35 Writing an informative chart title
6:59 Adding axis titles
7:24 Removing gridlines, borders, and axis lines
7:58 Coloring the data points
8:49 Scatter plot with two datasets
9:39 Adding a second data series
10:50 Adjusting axes for two datasets
11:55 Adding two trendlines and tagging them
13:26 Adding axis titles
13:43 Changing marker shapes
14:18 Adding and positioning a legend
14:45 Final cleanup
15:39 Recap
For more information on basic Excel skills, see my Microsoft Excel Basic Guide at https://lib.unb.ca/guides/microsoft-e...
Intro and outro music from Stereoalex at https://icons8.com/music/track/synthw...