From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Manage advanced charts and tables

Solution: Manage advanced charts and tables

From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365

Start my 1-month free trial

Solution: Manage advanced charts and tables

“

(upbeat music) - [Instructor] Welcome to the solution video for the chapter five challenge. For this challenge, you used the 05_07 challenge exercise file and I challenged you to complete all the tasks in five minutes or less. We have a lot to do, so let's get started. First, we'll save the file as my challenge in our chapter five folder. My challenge. Next, complete the tasks on project one and project two worksheets. Number one, create a clustered column chart in A13 that displays all the data below. Let's go ahead and select the entire range, insert, we're looking for a clustered column. Should be just a simple 2D. Let's move it down to A13. It doesn't have to be exact, just pretty close. Let me close this window. Next, display only hours as a secondary access as a red line chart. Let's go to chart tools design, change chart type, combo, so just the hours will be a line chart, so secondary access. We…

Contents