From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Unlock the full course today

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

Solution: Create advanced charts and tables

Solution: Create advanced charts and tables

From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Start my 1-month free trial

Solution: Create advanced charts and tables

“

- [Voiceover] Welcome to the Solution video for the Chapter Five Challenge. For this Challenge, we used the 05_05 Challenge Exercise file, and I challenged you to complete all the tasks for both projects in under five minutes. Let's get started. As always, our first task is to save the file as 'My 05_05 Challenge'. File, Save As, Browse back to Chapter Five folder, there we go. Complete the task on the Project 1 and Project 2 worksheets. Okay, Project 1. Create a Clustered Column Chart in A13 that displays each Department, the Hours worked, and the Gross Pay. So, we can select the Departments, and the Hours, and then Control+click and drag across to get the Gross Pay. We'll go to Insert, Clustered Column, and let's move that down to A13. Number two, add a Linear Forecast Trendline that forecasts three periods for Gross Pay. We'll click on the Chart, go to Design, Add Chart Element, Trendline, Linear Forecast, Gross Pay. Okay, let's go ahead and double-click on our Linear Forecast line…

Contents