From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Add and modify chart elements
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Add and modify chart elements
- [Instructor] Let's take a look at some of the different chart elements we can add to our charts. First, we'll take a look at axis titles and learn how to insert them and modify them. We'll learn how to insert and modify a chart title, take a look at data labels, how to insert a data table, show the grid lines, and I'll show you how you can choose where the legend is displayed. Let's jump right into our Elements workbook and we'll take a look at a chart that I have created that displays the 2017-2019 comparison. If you look at my data, I'm only showing the wedding cakes as the product. I already have a chart title showing here, but if I didn't, let me show you where I could go and add that to my chart. Under Chart Tools and Design, here are the chart elements that we can add. When I go to Axis Titles, I can display either a title at the horizontal axis or the vertical axis. And this is where I can select my chart title so that it's included. This one is currently above the 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.