From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Format charts
From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Format charts
- [Instructor] Now that you know how easy it is to quickly create a new chart, let's talk about how you can format those charts. On the Excel 2016 MOS exam, you may be asked to resize an existing chart or maybe move it another location, maybe to a separate worksheet. You may also be asked to add a horizontal or vertical axis title, change the layout, or change the style. In this video I'll demonstrate each of these skills so you'll be prepared for any chart challenges you come across on the exam. I have the O602 exercise file open, so let's get started. We're going to focus on our sales comparison worksheet. We have a nice pie chart that shows us the sales for our ahoy matey product. Notice that when I click on the chart to select it, I can see the ahoy matey product and the sales for 2014, 15, and 16, so when we select the chart it will actually show you by outlining the data where the data series is. I'm going to go back to my pie chart and show you how easy it is to resize a chart,…
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.