A Data Table, whereby you display worksheet cells as part of the chart, might be necessary when a chart is on its own separate sheet, but you can use it with any chart. Add a Data Table from one of the choices on the Quick Layout button or the Add Chart Element button - both located on the Chart Design tab.
- [Voiceover] We're looking at a worksheet…called Chart Data, and at first you don't see that…there's a chart below the data…starting down around row 22.…I'm going to scroll down here.…There's a chart.…Now, for whatever reason,…this chart is not close to the data,…and as we look at this, it could be helpful to see the data,…and yet we don't necessarily want to move…the other chart around or reposition this chart.…You can include what's called a data table.…Now, one approach, the standard approach,…is to select a chart, go to…the Chart Design tab in the ribbon,…Add Chart Element, and we see Data Table.…
With legend keys or without…legend keys, two differences there.…How about with legend keys, watch the chart.…We see the actual data being depicted in the chart.…Of course, the chart is quite tiny now.…We could make this bigger, taller,…that's going to help a bit.…The question is, do you really need…this if the data is up above, nearby.…And many times, you will not.…But it's your choice as to when to want to do this,…
Author
Released
7/25/2016- Selecting data for a chart
- Creating charts with keystrokes and ribbon icons
- Selecting the right chart type
- Adding titles, labels, and gridlines
- Choosing a chart layout
- Changing a chart's location
- Adding gridlines, data tables, and trendlines
- Formatting charts
- Creating column, bar, line, pie, and scatter charts
- Changing a chart's source data
- Creating Gantt and frequency charts
- Printing and sharing charts
- Converting a chart to a graphic
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel for Mac 2016: Tips and Tricks
with Dennis Taylor5h 27m Intermediate -
Excel for Mac 2016: Advanced Formulas and Functions
with Dennis Taylor6h 54m Intermediate
-
Introduction
-
Welcome51s
-
-
1. Create Basic Charts Quickly
-
2. Excel Chart Concepts
-
Identify chart elements3m 13s
-
Select the right chart type7m 17s
-
Use chart terminology2m 39s
-
Use Charts Ribbon tab2m 57s
-
-
3. Adjust Chart Appearances with Chart Design Tab Choices
-
4. Control Chart Element Options
-
Modify axes6m 59s
-
Link titles to content2m 28s
-
Add and edit data labels6m 57s
-
Add a data table3m 29s
-
Add error bars4m 28s
-
Work with gridlines4m 6s
-
-
5. Use Format Tab Options and Other Visual Features
-
6. Use Specific Chart Types
-
Pie charts and doughnut charts10m 53s
-
7. Change a Chart's Data Source
-
8. Specialized Excel Charts
-
Create combination charts4m 35s
-
Create Gantt charts6m 44s
-
Create frequency charts5m 43s
-
-
9. Print and Share Charts
-
Print charts5m 4s
-
-
10. In-Cell Chart Alternatives
-
11. Chart Manipulation Tools
-
Convert a chart to a graphic4m 32s
-
Conclusion
-
Goodbye30s
-
- 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 a data table