- On this worksheet called ChartFromTable,…we're seeing a column chart based on the information…in cells A1 through C6.…Now if I want to add June here,…I can simply highlight cells A5 and A6.…Drag from the corner,…and I've got June for the chart.…But the chart, of course, isn't reacting to that.…And if I put in values here, the chart will not react.…We can certainly make an adjustment.…I can click the chart.…And simply drag the fill handle…here in the lower right-hand corner on C6.…Drag that down.…
And then it makes room for that data.…But what if we update this every month?…Do we have to do that every month?…It's not that hard.…I mean, we could, of course.…What if we had a chart that updated every week?…Or how about one that updated every day, we added data?…This can get a little tedious.…When a chart is based on data,…if you add adjacent data to the bottom of the information…or on the right-hand side,…nothing happens unless that source data has been…formatted as a table.…A table is a relatively new feature.…
Not everybody is familiar with it.…
Author
Released
7/7/2015- Creating charts with one click
- Selecting the right chart types
- Changing chart type or source data
- Choosing a chart layout and style
- Saving charts as templates
- Editing titles, legends, and labels
- Adding a data table
- Analyzing data with trendlines
- Formatting the chart
- Customizing different chart types
- Creating Gantt and frequency charts
- Creating in-cell charts
- Moving charts
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2013 Essential Training
with Dennis Taylor6h 32m Intermediate -
Excel for Mac 2011 Essential Training
with Curt Frye6h 32m Beginner -
Photoshop CC 2015 Essential Training
with Julieanne Kost12h 27m Beginner
-
Introduction
-
Welcome54s
-
-
1. Creating Basic Charts Quickly
-
2. Understanding Excel Chart Concepts
-
Identifying chart elements2m 56s
-
-
3. Creating and Adjusting Chart Appearances with Charts Tab Choices
-
Changing a chart's type2m 52s
-
-
4. Using Chart Layout Tab Options
-
Linking titles to content1m 59s
-
Adding a data table2m 58s
-
Modifying axes11m 59s
-
Working with gridlines5m 8s
-
Adding error bars4m 55s
-
5. Using Format Tab Options and Other Visual Features
-
Adding shapes and arrows7m 55s
-
6. Customizing Specific Chart Types
-
Customizing line charts6m 18s
-
Customizing pie charts9m 20s
-
7. Changing a Chart's Data Source
-
8. Specialized Excel Charts
-
Creating combination charts4m 58s
-
Creating Gantt charts7m 2s
-
-
9. Printing and Sharing Charts
-
Printing charts4m 44s
-
-
10. In-Cell Chart Alternatives
-
11. Chart Manipulation Tools
-
Conclusion
-
Next steps37s
-
- 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: Adding new data to a chart using a table