From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Solution: Manage charts
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Solution: Manage charts
(upbeat music) - [Instructor] Welcome to the solution video for the chapter six challenge. For this challenge, we use the 06_05 challenge exercise file and I challenged you to complete all the tasks in five minutes or less. Let's jump right in. First, we'll save the file as my challenge in the chapter six folder. We'll go to file, save as, chapter six, my challenge, and click save. Complete the tasks on the project one worksheet. Let's jump right over to project one and look at task one. Using the data in cells B8 to E33, create a clustered column chart that shows the months as a legend and the products on the horizontal axis. Remember, you can use your name box to type a range in, and when I hit enter, it selects that range very quickly for me. Let's go on our insert tab, charts, and here is our clustered column chart. Let's move this over out of the way. Next, use slicer to show all sales of Canino, Palma, and Zarza. Let's click back in our table. Go to insert, slicer, select…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.