From the course: Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) Cert Prep
Unlock the full course today
Join today to access over 25,200 courses taught by industry experts.
Add and modify chart elements - Microsoft Excel Tutorial
From the course: Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) Cert Prep
Add and modify chart elements
- [Instructor] After you've created your charts, there are some really exciting chart elements that you can add such as a chart, title, access titles. You can add data labels to the different columns in your chart. We can put gridlines on, add a legend, and add a trend line. Well, let's take a look at our workbook and see what elements we can add to our charts. This is the information we're working off of. We have products and then quantity sold for Q1 and Q2 and then the sales for each of those products. Let's first take a look at our sales chart. We do have a chart title up here. If I needed to add one though, I could go to chart design, add chart elements. And this is where I can add my access titles, which would be on the left hand side and at the bottom, Chart titles, my data labels, add a data table underneath it. gridlines, legend, and a trend line. Well, let's start up at the top with access titles. Let's do a…
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.