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

Add and modify chart elements

From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Start my 1-month free trial

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…

Contents