Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
In the previous movie, I showed you how to create line charts where you measured something, such as daily sales revenue, and recorded the day where you took each measurement. In this movie, I will show you how to create XY scatter charts, where you measure two variables - such as daily sales and rainfall for the day - and plot the information on the chart. The idea is that you are trying to discover if there is any relationship between those two variables. There are mathematical ways to do it, but often times just a quick visual inspection can give you an idea as well. Here I have my data, and as I said, I have rainfall data and the number of customers that came in on a given day when that amount of rainfall occurred.
Unlike when I create a line chart where I have a time series where I would have one measurement for 2005, one measurement for 2006, and so on, because I am capturing two independent variables, I can have repeat values. So, for example, I have zero inches of rainfall in quite a few days, and I also have 196 customers on a couple of days as well. So in this case, repetition of values in either column doesn't matter. So to create the XY scatter chart, I click any cell in the data list, and then on the Charts tab, I can click Scatter and then click the Marked Scatter chart.
This is the basic scatter chart type. Click that and Excel creates my chart. And when you take a look at it, you see that on days when there is zero rainfall, there were generally between 150-200 customers, and then the more rain there was, the fewer people came by the store. You will notice that things pick up again. When there is one inch of rain, I guess people figure that it's raining. It's not overcast and drizzly like it is here, so we might as well go out. But that's the sort of thing that you can tell when you look at data using an XY chart.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90682 Viewers
80 Video lessons · 137970 Viewers
59 Video lessons · 56743 Viewers
52 Video lessons · 70366 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.