Join Dennis Taylor for an in-depth discussion in this video Identify core elements in a chart: plot area, chart area, gridlines, legends, part of Excel 2016: Charts in Depth.
- View Offline
- Exercise Files
- As we begin this course on Excel charts,…recognize that all the files I will be using…will be in the Exercise Folder on the desktop.…As I double-click Exercise File,…here are the files used for each of the chapters.…I'm going to open the Ch_01_ChartConcepts file first.…And that starts Excel.…And we're looking at the chart data sheet…in this particular workbook.…These are Excel charts.…If you've worked with Excel charting just a little bit,…or maybe you've never worked with them at all,…you can see some of the colorful varieties…on this worksheet.…
As I slide the mouse over a chart,…notice that various terms pop up.…These are referred to as chart elements.…Now, it can be a little bit intimidating…if you approach this as something you need to memorize.…You certainly don't.…But it's helpful to become familiar with chart terminology.…As I slide the mouse near the border,…you'll see the term Chart Area.…The outer border of charts are referred to as Chart Areas.…The inner sections are referred to as Plot Areas.…And as you move the mouse around…
The training wraps up with lesson on changing data sources for charts and printing and sharing charts.
- Identifying chart elements
- Selecting the right chart type
- Creating basic charts
- Creating sparklines
- Styling charts
- Moving and resizing charts
- Modifying axes
- Adding labels and gridlines
- Analyzing data with trendlines
- Inserting pictures, shapes, and text boxes
- Customizing column, bar, line, and pie charts
- Creating Gantt charts and other specialized Excel charts
- Changing data sources
- Printing and sharing charts
Skill Level Intermediate
1. Review the Basic Elements of an Excel Chart
2. Create Basic Charts
3. Style Your Charts with the Design Tab
4. Fine-Tune Your Chart Elements
5. Format Tab: Insert Pictures, Shapes, and Text Boxes
6. Adjusting Specific Chart Types
7. Other Specialized Excel Charts
8. New Chart Types in Excel 2016
9. Change a Chart's Data Source
Add new data using a table6m 38s
10. Print and Share Charts
Print your charts6m 15s
- 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.Cancel
Take 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.