In this video, learn 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 a chart.
- [Instructor] In the previous movie I should you how to create line charts which represent data over time. In this movie, I will show you how to create x, y scatter charts where you measure two numerical variables and plot the information on a chart. My sample file is the XYChart workbook and you can find it in the chapter seven folder of your exercise files collection. Working with our data scenario around Kinetico Corporation, let's say that we want to offer discounts to individuals who make a bid request for a solar panel installation by a certain date.
And we do our testing to determine the number of bid requests we received in response to each of these individual discounts. You can see the amount of discounts from 100 to $350 in column A and the corresponding increase in bid requests in column B. To create an x, y scatter chart with the way the data is laid out here in the table, I will click any cell in the table and then on the insert tab of the ribbon, I'll go to the charts area and then I will click the x, y scatter button.
And from here I just want to plot the individual points so I will click the Scatter button, the one on the top row to the left. So I'll click that and I get my chart. And let's interpret it. Along the bottom of the chart I see that I have my discount levels, my amount of discounts. I don't have a label, but I know that's what they are. And then on the x-axis I have the increase in bid requests. So I've got 20 for a $100 discount, 18 for 150, 30 and so on.
So it appears that up to about $300 discount I get a smooth increase in the number of bid requests. So unlike line chart where you capture a single measurement and plot it against a known value such as time, you can use a x, y scatter chart to capture two measurements both numeric at the same time and plot the data as points, where the values intersect in the body of the chart. Once the data's in the chart, you can look it over to see if you can detect any patterns in how the values change.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.