Inserting chart elements in your charts will give the user more information, such as a title which will indicate what information is included. In this video, learn how to insert axis titles, chart titles, legends, and many other chart elements into your charts.
- [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. …
Author
Released
7/1/2019- Importing data
- Formatting worksheets and workbooks
- Exporting workbooks
- Pasting data
- Modifying columns, rows, and cells
- Formatting cells
- Conditional formatting
- Creating tables
- Filtering and sorting table data
- Using references
- Performing calculations with functions
- Formatting text with functions
- Creating charts
- Taking the practice exam
Skill Level Intermediate
Duration
Views
Related Courses
-
Introduction
-
Who should take this course?1m 15s
-
1. Microsoft Office Specialist Exam Overview
-
2. Manage Worksheets and Workbooks
-
Inspect and export workbooks6m 33s
-
Configure print settings4m 15s
-
3. Manage Data Cells and Ranges
-
Format cells and ranges5m 39s
-
Insert sparklines5m 35s
-
4. Manage Tables and Table Data
-
Create and format tables3m 23s
-
Modify tables4m 19s
-
-
5. Perform Operations Using Formulas and Functions
-
6. Manage Charts
-
Create charts3m 40s
-
Modify charts2m 45s
-
Format charts3m 4s
-
Solution: Manage charts4m 31s
-
-
7. Final Practice Exam
-
Conclusion
-
Next steps22s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Add and modify chart elements