In the previous movie, I showed you…how to create line charts, where you…measured a value, such as the number…of room nights rented for a particular…type of room and recorded the time when…that measure was taken.…In this movie, I will show you how to create…XY scatter charts, where you measure two variables…such as an amount of a discount and…an increase in reserve nights and…put the information on a chart.…My data has a series of measurements.…The scenario, for this data is that the…operators of Landon Hotel offered discounts…per night, and checked to see what level of discount…led to what increase and the number of reserved nights.…

So that's the data you see here.…If there was a 10 dollar discount per night,…there was an increase in 14, 20 dollars also…increased by 14, 30 by 50 and so on.…So what I can do is create an XY chart that plots…the amount of the discount on one axis and the…increase in reserve nights on the other.…So with the cell in the data region selected…I can go to the insert tab, point to the…

Resume Transcript Auto-Scroll

Author

Released

3/9/2018

Learn everything you need to master the world's most popular spreadsheet program—now accessible from anywhere with an Office 365 subscription. Curt Frye provides a comprehensive overview of Excel for Mac, including manipulating workbook and cell data, using functions, printing worksheets, and collaborating with others. In the last half of the course, he covers more complex techniques, such as summarizing data with charts, working with external data, adding images and shapes, and automating routine tasks.